time formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Thank you Roger. I must have looked at this 50 times and did not catch that.
thank you so much
 
Back
Top