General discussion
-
Topic
-
Access – Round off to Hour
LockedI have a query with these values:
Field – Event time
Table – Event
Total – Group Byand
Field – Extra time
Table – Event
Total – Group ByNow 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.
All Comments
Viewing 7 reply threads