Thread: Very Simple Time/Hour Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danny Danny is offline
external usenet poster
  
Posts: 148
Default Very Simple Time/Hour Question
If the time on A1 = 12/3/07 8:00 A.M
A2 = 2 (hours)

On A3, what is the formula so if A1 + A2, it should show 12/3/07 10:00 A.M?

If A2 = 24 (hours), A3 should show 12/4/07 8:00 A.M.

Thanks
Reply With QuoteReply With Quote