# Round time to the closest half hour -access 2000

I have an attendance database and I need to round 'OUT" time to the closest hour. And then calculate overtime based on the 'End Time' (the time an employee should officially leave) and the OUT time (rounded):

Example:
Time Out   Round time

4:10            4:00
4:55            5:00
4:25            4:30

This is the formula I have in my query to calculate the overtime:

DateDiff("n",[End Time],[OUT])/60,0) AS OT

###### Who is Participating?

Commented:
Can't you use Round Time instead of OUT?

DateDiff("n",[End Time],[Round Time])/60,0) AS OT
0

Commented:
Will this work gor you?

Round Time: IIf(Minute([Time Out])<15,TimeSerial(Hour([Time Out]),0,0),IIf(Minute([Time Out])<45,TimeSerial(Hour([Time Out]),30,0),TimeSerial(Hour([Time Out])+1,0,0)))

Flyster
0

Author Commented:
fLYSTER

Your formula is working perfect to round the time. But how can I do it so my overtime 'OT' (overtime)  is also rounded. This is the formula I currently have:

DateDiff("n",[End Time],[OUT])/60,0) AS OT

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.