Very Simple Time/Hour Question

  • Thread starter Thread starter Danny
  • Start date Start date
D

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
 
=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting time...again 2
Difference between two date/time values 5
Time Situation 1
Convert times to text string 3
Formula help 0
Calcualting hours 6
rounding the results of two times 5
Need help with a Formula 4

Back
Top