HOW DO I ADD CLOCK TIMES, WHEN DIRIVED FROM A FORMULA?

C

CJGEREMINA

I want to sum a column of date which contains formualted CLOCK TIMES. I keep
getting 00:00:0, as my sum. When I manually ENTER THE TIMES, THEN SUM THEM I
GET WHAT I NEED, HOWEVER I NEED THIS AUTOMATIC, NOT MANUAL. ANY IDEAS??
 
G

Guest

Hi
What format do you want your answer? If you want hours and minutes, and your
cells are proper Excel times, the result should be as expected if you format
the cell as [hh]:mm
If this is not correct, post some of your 'times' for us to see, and also
post the formula you are using to get the total.
 
Top