Format in hour:minute

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:
I have a field to calculate the average of work time by week. The query
shows fraction numbers like 0.513, 0.655 and etc. I could multiply the result
by 24 to get hours and minutes in fraction, but is that any way that I can
show the time duration in this format e.g. 12:20 ?
Thanks in advance!
 
Do a search. This has been asked and answered several times in the last
week or two.

Use the following in your reports or forms...

=[lngDuration]\60 & Format([lngDuration] Mod 60, "\:00")
 
Thanks!

Rick B said:
Do a search. This has been asked and answered several times in the last
week or two.

Use the following in your reports or forms...

=[lngDuration]\60 & Format([lngDuration] Mod 60, "\:00")




Vincdc said:
Hello:
I have a field to calculate the average of work time by week. The query
shows fraction numbers like 0.513, 0.655 and etc. I could multiply the result
by 24 to get hours and minutes in fraction, but is that any way that I can
show the time duration in this format e.g. 12:20 ?
Thanks in advance!
Click to expand...
Click to expand...
 
Back
Top