Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LondonLion
 
Posts: n/a
Default converting seconds into minutes

Hi, I have a number of seconds eg 186.4 in one cell and would like to convert
this into minutes & seconds eg 03:06.4. Can this be done, I have tried
formatting and the TIME and CONVERT functions but seem unable to to this ??

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default converting seconds into minutes

=A1/24/60/60

Format Custom as mm:ss.0

--
Kind regards,

Niek Otten

"LondonLion" wrote in message
...
Hi, I have a number of seconds eg 186.4 in one cell and would like to
convert
this into minutes & seconds eg 03:06.4. Can this be done, I have tried
formatting and the TIME and CONVERT functions but seem unable to to this
??

Thanks



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default converting seconds into minutes

I hope Niek will not mind me explaining his answer.
Excel keeps time values as fractions of a day.
You have N seconds so dividing by 60 gives minutes, dividing again by 60
gives hours and finally dividing by 24 gives days.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Niek Otten" wrote in message
...
=A1/24/60/60

Format Custom as mm:ss.0

--
Kind regards,

Niek Otten

"LondonLion" wrote in message
...
Hi, I have a number of seconds eg 186.4 in one cell and would like to
convert
this into minutes & seconds eg 03:06.4. Can this be done, I have tried
formatting and the TIME and CONVERT functions but seem unable to to this
??

Thanks





  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave
 
Posts: n/a
Default converting seconds into minutes

Thanks. I've been having the same problem trying to use the CONVERT function
to no avail.

"Bernard Liengme" wrote:

I hope Niek will not mind me explaining his answer.
Excel keeps time values as fractions of a day.
You have N seconds so dividing by 60 gives minutes, dividing again by 60
gives hours and finally dividing by 24 gives days.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Niek Otten" wrote in message
...
=A1/24/60/60

Format Custom as mm:ss.0

--
Kind regards,

Niek Otten

"LondonLion" wrote in message
...
Hi, I have a number of seconds eg 186.4 in one cell and would like to
convert
this into minutes & seconds eg 03:06.4. Can this be done, I have tried
formatting and the TIME and CONVERT functions but seem unable to to this
??

Thanks






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 rows of hours and minutes to get a total Tipps Excel Worksheet Functions 1 November 4th 05 08:03 PM
Converting minutes to seconds Saray Excel Discussion (Misc queries) 4 September 9th 05 05:51 PM
Sum minutes and seconds to total hours deck4 Excel Discussion (Misc queries) 3 August 29th 05 02:34 PM
convert seconds to minutes and seconds Brian Excel Worksheet Functions 2 December 9th 04 10:45 PM
converting from digital degrees to degrees minutes seconds Patricio Boric Excel Worksheet Functions 1 November 28th 04 08:43 PM


All times are GMT +1. The time now is 06:33 PM.

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

About Us

"It's about Microsoft Excel"