6 Replies Latest reply: Mar 3, 2013 9:07 AM by Jerrold Green1
Reddkryten Level 1 Level 1 (0 points)

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