ExcelBanter - Very Simple Time/Hour Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Very Simple Time/Hour Question (https://www.excelbanter.com/excel-worksheet-functions/168258-very-simple-time-hour-question.html)

Danny

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

Niek Otten

Very Simple Time/Hour Question

=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

Danny

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

All times are GMT +1. The time now is 08:03 AM.