integer to time conversion off ?

[Aryzona]

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+270 = 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 2 people on the report with a single entry roll up exactly. one has a total of 78 min which rounds up properly to 1:18 I am completely lost as to why the other one is so off?

[strive4peace]

hi @Aryzona

this is missing the second parameter for the MOD operator:

[min] Mod ??

perhaps you meant to put 60 there? that will give only minutes left

Hours would be:
[min]\60

perhaps you want:

Format( [min]\60, "0" ) 
& ":" 
& Format( [min] Mod 60, "00" )
 

?

[Aryzona]

yes .. i missed typing the 60 ...

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

is what i actually have.

[strive4peace]

missed your equation ... skip this

[strive4peace]

I see the problem!!!

[strive4peace]

you need to wrap both parts with SUM

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