Sample Header Ad - 728x90

Timestamps in Numbers are only partially recognized as time?

0 votes
0 answers
159 views
I have a column with timestamps minutes, seconds and milliseconds. Originally they looked like this 6:24,120 (it is output from the time command) Pasting it into Numbers causes weird results. I can add them using =A1+A2 but using =sum(A1:A2) returns 0 and if I use average I get an error message "Numbers can’t be divided by zero." (which is odd, because even if the sum doesn't work and returns 0, you can still perform 0/2 - it is not an invalid operation). I have tried changing the format to 6m24s120ms, which Numbers reformats to 6m 24s 120ms but the result is the same as when using colons and commas as separators. How do I make average and sum work in these data?
Asked by d-b (3494 rep)
Feb 24, 2023, 05:44 PM