Solved How to add fields with the Short Time format?

[arnelgp]

Multiplying by 24 will always work with the result being hours. That’s how durations work.

will it work if you only have minutes on your date field?

 

[DHookom]

will it work if you only have minutes on your date field?

It will result in the portion of an hour. Multiply by another 60 to get minutes since there are 60 minutes in an hour.

 

[Ole]

here is a demo with some vba (but not on the report).
see Query1 first and check out "TotalMinutes" calculated column.
next view Table1 report in design view and analyze the design.
next check out the function fnConvertToHrMin() in Module1.
this function is being used in the Table1 Report.
now open Table1 report in Print preview.
View attachment 116059

Wouw! Thanks a lot
This is exactly what I needed.

I very grateful!

 

[arnelgp]

did you apply it to your report?
you also need to set those dummy textboxes' (yellow color on design view), Visible Property to No
so it will be hidden in the report/print preview view.

 

[Ole]

did you apply it to your report?
you also need to set those dummy textboxes' (yellow color on design view), Visible Property to No
so it will be hidden in the report/print preview view.

I haven't done that yet. I need to do some changes since I got inspired by your way to do it. Unfortunately, I'm a bit busy today, so I might need to wait until the weekend.
Thank you for your help. It's much appriciated