time formatting

[Wanna Learn]

Hello I have a column formatted as time . so 141:29:51 looks like this in
the formula bar 01/05/1900 9:29:51 PM the problem is the one cell is
158:121:38 the formula bar reads 158:121:38 so when I try to add the column
I get #Value. Now I tried reformatting this cell and eventhough it is
formatted to time - 33:30:55 when I sum the column I still get #VALUE as
an answer HELP! and thanks

 

[Roger Govier]

Hi

The problem is your value 158:121:38 is a Text value not a Time/Date value.
It looks like a typo, and should be
158:21:38
as it is clearly impossible to have 121 minutes in an hour.

Change the value, then click on your cell with the formula again and press
Enter.

 

[Wanna Learn]

Thank you Roger. I must have looked at this 50 times and did not catch that.
thank you so much