How do I add numbers to time?

T

trob

How do I add numbers to time? I have a start time in time format of 7:30 a.m.
I calculate a project will to 4.25 hours, in general number format, i.e., 4
hours and 15 minutes. When I add the two, it does not give me 11:45 a.m., but
instead it still shows 7:30 a.m. I tweaked with the format in the results
cell to no avail.
 
D

Dave

Hi,
When you add numbers to time, XL treats those numbers as days, so you need
to divide by 24 if you want hours.

If 7:30 AM is in A1...
=A1+(4.25/24)
Format like A1

Regards - Dave.
 

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

Top