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