Adding two times values together

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to add two cells together, one with a time of 17:00 and another with a
duration of 3.25 hours (3 and quarter hours). I want the answer to equal
20.25.

In otherwords, I want to add 3.25 hours onto 5:00pm to give me 8:15 in the
evening.

Any help appreciated.
 
Format the cell that contains the sum function using the following custom
format:

[h]:mm

Click FORMAT, CELLS and click the NUMBER tab if necessary. Select CUSTOM
from the CATEGORY list and in the TYPE field enter the format mask stated
above.
 
=A2+(B2/24)

format as time

where A2 holds the time value and B2 the decimal value


--


Regards,


Peo Sjoblom
 
You're "other words" are confusing me...

If A1 contains 17:00:00 (hh:mm:ss) and A2 contains 3.25:

I could use this formula to return 20.25:

=(A1+A2/24)*24
(Make sure the result is not formatted as time)

I could use this formula to return 20:15:00
=A1+A2/24
(and format this as HH:MM or HH:MM:SS)
 
Dave Peterson said:
You're "other words" are confusing me...

If A1 contains 17:00:00 (hh:mm:ss) and A2 contains 3.25:

I could use this formula to return 20.25:

=(A1+A2/24)*24
(Make sure the result is not formatted as time)

I could use this formula to return 20:15:00
=A1+A2/24
(and format this as HH:MM or HH:MM:SS)
Click to expand...
 
Thanks

Kevin B said:
Format the cell that contains the sum function using the following custom
format:

[h]:mm

Click FORMAT, CELLS and click the NUMBER tab if necessary. Select CUSTOM
from the CATEGORY list and in the TYPE field enter the format mask stated
above.
--
Kevin Backmann


Stuart said:
I want to add two cells together, one with a time of 17:00 and another with a
duration of 3.25 hours (3 and quarter hours). I want the answer to equal
20.25.

In otherwords, I want to add 3.25 hours onto 5:00pm to give me 8:15 in the
evening.

Any help appreciated.
Click to expand...
Click to expand...
 
Thanks.

Dave Peterson said:
You're "other words" are confusing me...

If A1 contains 17:00:00 (hh:mm:ss) and A2 contains 3.25:

I could use this formula to return 20.25:

=(A1+A2/24)*24
(Make sure the result is not formatted as time)

I could use this formula to return 20:15:00
=A1+A2/24
(and format this as HH:MM or HH:MM:SS)
Click to expand...
 
Back
Top