Access - Round off to Hour
I have a query with these values:
Field - Event time
Table - Event
Total - Group By
and
Field - Extra time
Table - Event
Total - Group By
Now in the report it works off of:
=([SumEvTime]+[SumExTime])
Now it gives me total time in minutes.
What can I do to it to make it convert to hours?
All I can find in Access is:
Syntax
CONVERT(number,from_unit,to_unit)
Number is the value in From_unit to convert.
From_unit is a text value that specifies the units for Number.
To_unit is a text value that specifies the units for the result.
That is Chineese to me. No examples or anything.
Please assist if you can.
Thank you.
God bless.