Database Developer

LillyC

<div>
This should give you the number of hours between in/out times:<br />
Hours = DateDiff(&quot;h&quot;,[Datetimein],<wbr />[datetimeo<wbr />ut])<br />
This should give you the leftover minutes after you subtract the full hours:<br />
Minutes = DateDiff(&quot;n&quot;,[DatetimeIn],<wbr />[datetimeO<wbr />ut])-((Dat<wbr />eDiff(&quot;h&quot;,<wbr />[DatetimeI<wbr />n],[dateti<wbr />meOut]))*6<wbr />0)<br />
<br />
Works for me....
</div>


This should give you the number of hours between in/out times:
Hours = DateDiff("h",[Datetimein],[datetimeout])
This should give you the leftover minutes after you subtract the full hours:
Minutes = DateDiff("n",[DatetimeIn],[datetimeOut])-((DateDiff("h",[DatetimeIn],[datetimeOut]))*60)

Works for me....

<div>
The above works if you want separate hours and minutes, or you could parse Gustav's solution results.
</div>


The above works if you want separate hours and minutes, or you could parse Gustav's solution results.

<div>
<div class="content wysiwyg-content">
I just can't get this right grrrrrrr, I'm trying to show the number of hours and minutes, I can get the hours and the minutes separately but want to show as hours/minutes, eg 100 hours = 1 hour 40 minutes<br />
<br />
Lateness Total Hours: (DateDiff('n',[Time due in],[Time arrived])/60)<br />
Lateness Total Minutes: (DateDiff('n',[Time due in],[Time arrived]))<br />
Lateness Total Hours/Minutes: (DateDiff('n',[Time due in],[Time arrived]))-(DateDiff('n',[<wbr />Time due in],[Time arrived]))/60
</div>
</div>


I just can't get this right grrrrrrr, I'm trying to show the number of hours and minutes, I can get the hours and the minutes separately but want to show as hours/minutes, eg 100 hours = 1 hour 40 minutes

Lateness Total Hours: (DateDiff('n',[Time due in],[Time arrived])/60)
Lateness Total Minutes: (DateDiff('n',[Time due in],[Time arrived]))
Lateness Total Hours/Minutes: (DateDiff('n',[Time due in],[Time arrived]))-(DateDiff('n',[Time due in],[Time arrived]))/60

How to show hours and minutes in a query in MS Access

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.