Formatting Hours and Minutes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
One way:

=TEXT(INT(A1/60),"#,##0:")&RIGHT(TEXT(A1/1440,"hh:mm"),2)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert minutes and seconds (in a date format) to numbers 6
Calculating Hours, Minutes and Seconds 6
Display minutes more than 60 2
Converting time (raw) into ss:mm 1
i want to convert decimals into time format 3
Converting Seconds to Hours, Minutes, Seconds 3
hour minutes to minutes 2
How to convert number in to time lenght, minutes and seconds? 3

Back
Top