microsoft works or excel time formula

  • Thread starter Thread starter Tubs
  • Start date Start date
T

Tubs

I was wondering if anyone knew how to add time and dates together in works,
this is what I need,
If I leave the house on 6/25/03 at 14:00 and travel 56 hours is there a
formula that would tell me the day and time of arrival? I really need this
and would appreciate any and all help.
Thanks
Tubs
 
Cell A1 6/25/03 14:00:00
Cell A2 =52/24
Cell A3 =A1+A2

Excel recognizes hours as parts of days and each day has a value of 1

HTH

PC
 
Back
Top