How do I calculate time?

K

Kris

I know about the Diff Date function, it calculates the difference between dates. What will I use to calculate the difference between times? For example, a person was dispatched to a location for a delivery at 12:00PM and he departed at 2:00PM the total time is 2 hours. How do I do that ?
 
F

fredg

I know about the Diff Date function, it calculates the difference between dates. What will I use to calculate the difference between times? For example, a person was dispatched to a location for a delivery at 12:00PM and he departed at 2:00PM the total time is 2 hours. How do I do that ?
Click to expand...

From the VBA Help files:
DateDiff("h",[Time1],[Time2])
 

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

Calculate the median value before a specified list 0
Work Budget Salary vs Real Time Salary 0
Over time? 4
Calculate elapsed time excluding specific timeframe 10
Calcualte date and time 3
Total working hours problem if it start from 30 at night and ends onthe 31 morning 3
Finding the proper style field and the numbered paragraph value within the style 0
over time in a sheet 2

Top