General discussion
July 30, 2004 at 07:35 AM
borginva

Access – Round off to Hour

by borginva . Updated 21 years, 7 months ago

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.

This discussion is locked

All Comments