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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to sum with empty values 9
How to just display the Time part of a Date/Time value? 2
Converting Time to Format That Items Per Hour Can Be Calculated 1
Time Calculation thought process 8
Quarterly Overtime Hours Reply 6
Calculations using time and currency 2
how to multiply hoursAndMinutes i.e 9:30 by pay rate $7.5 2
Lost in time! 5

Back
Top