<div>
Will this work gor you?<br />
<br />
Round Time: IIf(Minute([Time Out])&lt;15,TimeSerial(Hour([<wbr />Time Out]),0,0),IIf(Minute([Tim<wbr />e Out])&lt;45,TimeSerial(Hour([<wbr />Time Out]),30,0),TimeSerial(Hou<wbr />r([Time Out])+1,0,0)))<br />
<br />
Flyster
</div>


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

<div>
fLYSTER<br />
<br />
Your formula is working perfect to round the time. But how can I do it so my overtime 'OT' (overtime) &nbsp;is also rounded. This is the formula I currently have: <br />
<br />
DateDiff(&quot;n&quot;,[End Time],[OUT])/60,0) AS OT<br />
<br />

</div>


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



<div>
<div class="content wysiwyg-content">
I have an attendance database and I need to round 'OUT&quot; 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):<br />
<br />
Example:<br />
Time Out &nbsp; Round time &nbsp;<br />
&nbsp;<br />
4:10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4:00<br />
4:55 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5:00<br />
4:25 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4:30 &nbsp;<br />
<br />
This is the formula I have in my query to calculate the overtime: <br />
<br />
&nbsp;DateDiff(&quot;n&quot;,[End Time],[OUT])/60,0) AS OT<br />
<br />

</div>
</div>


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



Round time to the closest half hour -access 2000

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.