Adding hours

F

Frank Kabel

Hi
enter these time values in xdcel time format. e.g.
A1: 6:45
B1: 0:25

and use the formula =A1+B1
and format the resulting cell also as time
-----Original Message-----
I have an excel chart. I'm adding hours, i.e. 6.45
+ .25! I want the total to add up to 7hr 10 min, not
6.70. How do I do this? I do have this "total" cell
referenced in a workbook back to the 1st page so that when
I add time it reflects on the first page.
 

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