A challenge, Serious help requested
Hi 4844,
Your link to excelforum failed.
To calc your time away you just need to subtract the time and dates
as follows.
A1 : Departure date and time
B1 : Return date and time
In C1 put the formula =(B1-A1)*24 and format the cell as general.
HTH
Martin
|