View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charlie7805 Charlie7805 is offline
external usenet poster
 
Posts: 11
Default date/time calculation needed

I'm looking for a simple formula to add 140 hours from a entered data/time.
Example: In D6 a date/time is entered. In E6 140 hours is added giving the
results in a new date/time format.

This is probably simple but having problems making it work. Also, how would
these cells be formatted?

Thxs in advance