Total Time (format Problem ?)

[REDaughdril]

I am running a query of time. It have 5 different categories of time in the short time format that I enter (12:00, 06:00, etc) When I total all the times it totals it in a 24 hour format and not in total hours worked. (12:00 + 06:00 + 06:00= 00:00, I need 24:00). Thanks so very much.

 

[Jon K]

Total Time: Format(Int([Time1]+[Time2]+[Time3])*24 + Format([Time1]+[Time2]+[Time3],"h"),"00") & Format([Time1]+[Time2]+[Time3],":nn")


Note  The total time returned is now a text string and can no longer be formatted as Short Time.

 

[REDaughdril]

Thanks

Plugged it in and it worked great. Thanks for the help.