calculating time
Subtract the earlier from the later and format the result cell as [h]:mm or
just [h]
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"tom ossieur" wrote in message
...
Hi,
given a departure and arrival date and time, how to calculate the travel
time (in hours)
A B C D
From To
10-Oct 00:05 12-Oct 14:13
Cell E should give the total amount of hours.
Many thanks!
tom
|