Very Simple Time/Hour Question

[Danny]

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

 

[Niek Otten]

=A1+(A2/24)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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

 

[Danny]

Thanks a lot Niek. Have a great day!