Remember Me?

#1
January 20th 05, 01:29 PM
 Anthony Slater Posts: n/a
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?

#2
January 20th 05, 02:24 PM
 JE McGimpsey Posts: n/a

One way:

=TEXT(INT(A1/60),"#,##0:")&RIGHT(TEXT(A1/1440,"hh:mm"),2)

In article ,
"Anthony Slater" wrote:

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?

#3
January 20th 05, 03:03 PM
 Anthony Slater Posts: n/a

Thanks M8

That worked a treat !!

"JE McGimpsey" wrote:

One way:

=TEXT(INT(A1/60),"#,##0:")&RIGHT(TEXT(A1/1440,"hh:mm"),2)

In article ,
"Anthony Slater" wrote:

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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Randberger Excel Discussion (Misc queries) 4 January 19th 05 09:49 PM Lady Luck Excel Discussion (Misc queries) 4 January 2nd 05 07:56 PM DMachado Excel Discussion (Misc queries) 7 January 1st 05 10:45 PM kkrebs Excel Discussion (Misc queries) 5 December 30th 04 07:13 PM LolaK Excel Discussion (Misc queries) 1 December 14th 04 05:23 PM

All times are GMT +1. The time now is 03:11 PM.