Newsroom Update

New features come to Apple services this fall. Learn more >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How do I get numbers to provide a sum of times where total is greater than 24 hours?

I have to keep track of flight time for my job as a pilot. The most important value is total time flown per year, but I cannot figure out how to get numbers to sum times when the total is greater than 24. MsExcel does it by using a time format that brackets the hour value. This tells excel to ignore the 24 hour limit. How do I do this in Numbers? or do I have to purchase Excel to get the job done?

MacBook Air (11-inch Mid 2013), iOS 7.0.4

Posted on Jan 5, 2014 2:03 PM

Reply
Question marked as Best reply

Posted on Jul 6, 2017 8:11 AM

Hi Lessbarb,


Please post a screen shot of the minutes data.

User uploaded file

Twenty minutes should be 20m

0:20 is the Time portion of a Date & Time format and is meaningless to add.

Changing the cell format to Duration does not "stick"; Numbers (correctly) reverts it to Date & Time.


Regards,

Ian

17 replies

How do I get numbers to provide a sum of times where total is greater than 24 hours?

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