Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 20th 05, 01:29 PM
Anthony Slater
 
Posts: n/a
Default 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   Report Post  
Old January 20th 05, 02:24 PM
JE McGimpsey
 
Posts: n/a
Default

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   Report Post  
Old January 20th 05, 03:03 PM
Anthony Slater
 
Posts: n/a
Default

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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding minutes to time Randberger Excel Discussion (Misc queries) 4 January 19th 05 09:49 PM
Avoid user having to enter 00 hours when using [mm]:ss format Lady Luck Excel Discussion (Misc queries) 4 January 2nd 05 07:56 PM
Formula for time DMachado Excel Discussion (Misc queries) 7 January 1st 05 10:45 PM
How do I convert times from hours to minutes? kkrebs Excel Discussion (Misc queries) 5 December 30th 04 07:13 PM
Problems calculating total hours LolaK Excel Discussion (Misc queries) 1 December 14th 04 05:23 PM


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

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017