How do I add numbers to time?

  • Thread starter Thread starter trob
  • Start date Start date
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.
 
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

Similar Threads

Calculating difference between times on 2 dates 4
Time elapsed calculation 6
Formula to subtract time 2
Calculating the number of minutes between days 5
Subtract time between certain days/work hours? 2
BIN2DEC conversion for large binary numbers 19
Calculating Project Time 1
Automatically insert a date value based on the value from another cell 6

Back
Top