View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
MartinW
 
Posts: n/a
Default 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