How to calculate average and standard deviation for minutes:seconds?

For a sequence of minutes:seconds, Average and Std give useless values. Is there another method?

MacBook Air 13″, macOS 14.8

Posted on Aug 23, 2026 10:19 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 23, 2026 5:42 PM

Your data might actually be a date instead of a duration. This occurs automatically if you enter something like "1:30" in a cell. Numbers will understand it as today's date at 1:30 AM. You can check that this is the case by formatting the cell to display the date (instead of "None").


To enter a duration, use the "Xm Ys" where X is the number of minutes and Y the number of seconds, e.g. "1m 30s" for 1 minute and 30 seconds. If the cells are properly a duration, you won't have issue with the statistics functions (see below). Note that once the cells do contain a duration, you can modify their format to display them as "X:Y" (see column E below, where E2 is set to B2).


3 replies
Question marked as Top-ranking reply

Aug 23, 2026 5:42 PM in response to R. E. Rowan

Your data might actually be a date instead of a duration. This occurs automatically if you enter something like "1:30" in a cell. Numbers will understand it as today's date at 1:30 AM. You can check that this is the case by formatting the cell to display the date (instead of "None").


To enter a duration, use the "Xm Ys" where X is the number of minutes and Y the number of seconds, e.g. "1m 30s" for 1 minute and 30 seconds. If the cells are properly a duration, you won't have issue with the statistics functions (see below). Note that once the cells do contain a duration, you can modify their format to display them as "X:Y" (see column E below, where E2 is set to B2).


How to calculate average and standard deviation for minutes:seconds?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.