View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danny Danny is offline
external usenet poster
 
Posts: 148
Default Very Simple Time/Hour Question

Thanks a lot Niek. Have a great day!

"Niek Otten" wrote:

=A1+(A2/24)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Danny" wrote in message ...
| 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