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
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.
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
+ .25! I want the total to add up to 7hr 10 min, not-----Original Message-----
I have an excel chart. I'm adding hours, i.e. 6.45
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.