yes .. i missed typing the 60 ...
=Sum([tmin])\60 & Format([tmin] Mod 60,"\:00")
is what i actually have.
Aryzona
Last Activity: Jul 14 '20, 03:25 AM
Joined: Jul 14 '20
Location:
-
integer to time conversion off ?
I have a report that needs to track the total time spent on a project daily. I have converted the hours to minutes, and am using the Format([min] Mod, "\:00") to convert them to hours & minutes. One person has 360 min +420+420+450+27 0 = 1920 total minutes which divided by 60 = 32 hours --- the report shows a subtotal of 32.30 hours?? There are no extra decimal points in the integer it is set at 2 and only 2 can be entered. the...
No activity results to display
Leave a comment: