minutes calculation 2

[pcrmil]

Hi All,
I created a report,that report is about printed hrs and minutes totaled.

Minutes are storing
0.15
0.40
0.15
0.15
etc.

I used the formula on the report: group footer. Ex. if total minutes are 205 i used the formula below.
Sum([mts]/60*100)
to total. The minutes are totaled to 3hrs 42mts but it has to be 3hrs 25 mts. What I am doing wrong? Please explain how to correct the formula above to get correct answer. I will greatly appreciate if you could help me.

 

[pcrmil]

KLmorgan,

Thank you, I did what you said. Its still not working. Could you please write more dedtails about the syntax as soon as possible because there is a deadline to finish this report.

I will greatly appreciate if some one could help me.

 

[PHV]

Perhaps this ?
=Sum([total]*10)\6 & "hrs " & (Sum([total]*10) Mod 6) & "mts"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886