Calcuting Time Sheets

[gcole]

I am creating a form to calculate hours worked in a time sheet. Adding and subracting time fields gives the correct answer but it in not a value. How can I convert it to a value? The val() command only returns the hour. I need the total minutes.

 

[dpaulson]

Check out DateDiff() function, It has a interval of minutes that will do the trick.
David Paulson

 

[swilliams]

Use the Hour and Minute functions. So, if a user enters a tie of 2 hours 45 minutes,

Hour(#2:45#) = 2

and

Minute(#2:45#) = 45

So, to calculate the total number of minutes:

Dim lMinutes As Long
lMinutes = (60*Hour(#2:45#)) + Minute(#2:45#)

Simon

 

[gcole]

Thank you! I tried the hour() command but couldn't get the minutes.

 

[swilliams]

Can you post what you are trying, as the code I posted works??

Simon