Formatting Hours and Minutes
Hi
I'm using the simple formula =a1/(24*60) to convert my seconds to minutes.
Then I'm formatting the cell to Time (xx:xx:xx)
However, as my seconds are very large, the time looks a bit confusing. ie:-
9065378 seconds converts to 151089:38:00
How can I convert the seconds to minutes but also include a comma as a
seperator?
Or any other suggestions?
|