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