Adding two times values together
Thanks
"Kevin B" wrote:
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" wrote:
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.
|