calculate time between a start and end time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried to use the datediff() function to calculate my time. It works, but it
only works in whole numbers. It doesn't work for 1:30-2:00, which is .5
hours. I hope you can help me!!
 
use DateDiff to work out in minutes (or even seconds, if required) and then
convert the difference to decimal hours.
 
You must log in or register to reply here.

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

Calculating time difference using working days and working times 6
Workday calculations for weekends 9
Calculating Time Error????? 3
Totaling Times 2
Time in calculated field for shifts going past midnight 0
Time Calculation 3
Time Calculation 1
Time difference 2

Back
Top