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.