how do you work with time?

  • Thread starter Thread starter Annelie
  • Start date Start date
A

Annelie

I am trying to create input for a time card
Start: 07:44 (shorttime format)
End: 17:13 (shorttime format)
HoursWorked: 09:29 (shorttime format)- formula was =[end]-[start]

Now how do I work with my HoursWorked
I need to work with the hours
I tried Int([hoursworked])
it give me an error
Everything I have tried gives me an error
Help
Annelie
 
Try DateDiff("n",End, Start) /60
This calculates the difference between end and start in minutes and then
divides by 60. If you need greater accuracy, you can use "s" for seconds and
then divide by 3600.
 
Back
Top