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

Convert number to time?

Hi. I have a slightly odd question. Is there a way to get pages to convert a number to a time?


I have a document with a list of times, something took 5 minutes 26 seconds, but it was typed in as the number 5.26, is there any formula that could convert that number value into a time value?


I need to add up a total for a bunch of values written like this, but straight up adding will give me 11.99 instead of 12m39s.


Any suggestions would be very much appreciated.

iPad, iOS 5.1

Posted on Feb 13, 2013 11:47 AM

Reply
Question marked as Best reply

Posted on Feb 13, 2013 6:05 PM

The only way I can think to do this would be to use the Trunc function and seperate the minutes form the seconds, then sum up the seconds & divide by 60. Let's say 5.26 is in cell a1. In cell b1, you could typt =Trunc(a1,0), that will give you the minutes. In cell c1 you could type =a1-b1, that will give you the seconds. then just paste it down, and then sum them up

6 replies
Question marked as Best reply

Feb 13, 2013 6:05 PM in response to Reddkryten

The only way I can think to do this would be to use the Trunc function and seperate the minutes form the seconds, then sum up the seconds & divide by 60. Let's say 5.26 is in cell a1. In cell b1, you could typt =Trunc(a1,0), that will give you the minutes. In cell c1 you could type =a1-b1, that will give you the seconds. then just paste it down, and then sum them up

Feb 14, 2013 5:49 AM in response to Reddkryten

Hi Redd,


Here's a solution in the same vein as mkral's, using a slightly different set of functions...


User uploaded file

The expression in Column B is:


=DURATION(,,,INT(A),RIGHT(A,2))


INT(A) grabs what is left of the decimal and RIGHT(A,2) grabs what is to the right of the decimal. The DURATION function puts the minutes and seconds parts together into one Duration value.


Jerry

Convert number to time?

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