Time Calculation differece between query formula and report formual

[Liz_I3]

Hi
I am working in Access 2010
I have a totals query with this formula
Time In Hrs: Format(([Time]\60)+(CInt(([Time]-(60*([Time]\60)))/15)*15/60),"Fixed") this is grouped on Sum
Time is a field that is grouped on sum

If I put the Time In Hrs as an unbound field in a report instead of in the query and use this formula I get a difference of .25 on some of the calculations.

=Format(([SumOfTime]\60)+(CInt(([SumOfTime]-(60*([SumOfTime]\60)))/15)*15/60),"Fixed")

Example in the query 340 min converts to 6 hr. yet on the report it is 5.75

395 is query is 6.75 on the report 6.50

Could someone explain why the difference

Thanks very much
Liz

 

[mole999]

I'm guessing, but i think CInt might be the problem. If it is what I think it is, it could be truncating to a whole number. Not sure how maths works in Access

 

[Liz_I3]

Thanks but if it was truncating would it not round up to 6, 7 etc. The difference I am getting is only .25 in many cases 6.75 vs 6.50

L

 

[Liz_I3]

OK I fixed it (I hope its correct) in the query instead of Time In Hrs: Sum(Format(([Time]\60)+(CInt(([Time]-(60*([Time]\60)))/15)*15/60),"Fixed"))
I changed it to Time In Hrs: Format((sum([Time])\60)+(CInt((sum([Time])-(60*(sum([Time])\60)))/15)*15/60),"Fixed"))
Seems like a small change but now it does match the same calculation in my report

Thanks
L

 

[mole999]

glad you found a solution