Question of time

[DRSmith]

I need to be able to calculate (in a query, if possible)the elapsed time between the fields TimeIn and TimeOut.&nbsp;&nbsp;I would prefer the answer just show the total minutes elapsed.<br>Can anyone suggest a way to do this?&nbsp;&nbsp;<br>Thanks in advance!

 

[rhicks]

Seems like I just answered this question, maybe at another site.<br><br>Add this fuction to a module:<br><br>Public Function fMinutesElapsed(interval) As Integer<br>If IsNull(interval) Then Exit Function<br>fMinutesElasped = Int(CSng(interval * 1440))<br>End Function<br><br>To use this fundtion in an expression in a query, try this:<br><br>Minutes:fMinutesElapsed([TimeOut]-[TimeIn])<br><br>HTH<br>RDH <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>

 

[rhicks]

Seems like I just answered this question, maybe at another site.<br><br>Add this function to a module:<br><br>Public Function fMinutesElapsed(interval) As Integer<br>If IsNull(interval) Then Exit Function<br>fMinutesElasped = Int(CSng(interval * 1440))<br>End Function<br><br>To use this function in an expression in a query, try this:<br><br>Minutes:fMinutesElapsed([TimeOut]-[TimeIn])<br><br>HTH<br>RDH <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>