how to find the average for minutes and seconds excel for mac

Find The Average For Minutes And Seconds Excel Serial Number 12

Although this is certainly the correct result, it means you must manually calculate how many days, hours, and minutes the total represents.

In cell A11, you have a regular SUM function that is summing up the total hours-i.e., SUM(A1:A10).

If the total of this sum is to exceed 24 hours, the result cell housing the SUM function should be formatted as h:mm.

Assume the result of this total is 306:26:00, which, of course, represents 306 hours and 26 minutes.

However, this does tell you how many dayshoursminutes this total represents.

This function will return the whole number 12 from the value 12.76805556.

This is how many days there are.

Here you are using MOD(A11,INT(A11) to return the remainder of 12.76805556 divided by 12, which is 0.76805556 (the number of minutes represented as a decimal number).

Now you need to multiply that by 24 (which is 18.433333) to return a number that will represent the minutes.

As you want only the whole number (18), we have nested the formula MOD(A11,INT(A11))24 into the INT function.

Find The Average For Minutes And Seconds Excel Serial Number 12

The function will return 26 from the serial number 12.76805556.

As the result returned from the MINUTE function will never be a numeric value, it is wise to at least keep the original SUM function, which returns the total as hours in a cell, so that it can be referenced and used in further calculations if needed.

The row that houses the total as hours can, of course, be hidden.

How To Find The Average For Minutes And Seconds Excel For Mac