total time query displays incorrect value

[jammyp]

Hi,
I am using

Total_Time: Format([totaltime_mins]/60,"00") & ":" & Format([Totaltime_mins] Mod 60,"00")

To display the time as hours and minutes but this formula doesn't always work correctly.

for instance if the totaltime_mins = 90 then total_time is displayed as 2:30

also if totaltime_mins = 40 then thotal_time is displayed as 1:40

does anybody know why this is not working correctly ?


kind regards,
jamie

 

[neileg]

You only want the integert part for your hours. Try this
Total_Time: Format(Int([totaltime_mins]/60),"00") & ":" & Format([Totaltime_mins] Mod 60,"00")

 

[jammyp]

thanks

Hi, that seems to work. thank you.