Rounding up a time in a query

[angie]

Hi I use the following to calculate the time between a starting time and ending time. I would like it to round up to the next hour only.


So if it would be 5.38 I would like it to round up to 6 hours.

Time On Job: DateDiff("n",[arrived time],[completed time])\60 & "." & Format(DateDiff("n",[arrived time],[completed Time]) Mod 60,"00")

The above works to calculate just need it to round up to the next hour.

Thank you Angie

[Micron]

DateDiff("h",[DateOne],[DateTwo]) should work.
12/18/2016 7:45:00 AM > 12/18/2016 11:00:00 AM is 4 even though it is 3 hours and 15 minutes.

[angie]

Thanks everyone it works great.

Angie