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])
 
Top