Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 192
Default Convert seconds to hh:mm:ss?

Is it possible with a single formula to convert a number of seconds
sssss to the text hh:mm:ss please?

For example, 6185 would become 01:43:05.

--
Terry, East Grinstead, UK
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default Convert seconds to hh:mm:ss?

Hi Terry,

Am Mon, 16 Nov 2015 20:31:11 +0000 schrieb Terry Pinnell:

Is it possible with a single formula to convert a number of seconds
sssss to the text hh:mm:ss please?

For example, 6185 would become 01:43:05.


divide the seconds by seconds per day.
Your seconds in A1. Then in B1:
=A1/86400
and format the result cell h:mm:ss


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default Convert seconds to hh:mm:ss?

Hi Terry

Am Mon, 16 Nov 2015 21:42:29 +0100 schrieb Claus Busch:

=A1/86400


or without a helper column:
Write 86400 in a empty cell = copy that cell = select all cells with
your seconds = Paste Special = Divide = Format the cells hh:mm:ss


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 192
Default Convert seconds to hh:mm:ss?

Hi Claus,

Excellent, thank you - I was hoping you'd be around!

That combination of formatting and formulas is a powerful one I must
try to use more often.

Best wishes,

--
Terry, East Grinstead, UK

====================

Claus Busch wrote:

Hi Terry

Am Mon, 16 Nov 2015 21:42:29 +0100 schrieb Claus Busch:

=A1/86400


or without a helper column:
Write 86400 in a empty cell = copy that cell = select all cells with
your seconds = Paste Special = Divide = Format the cells hh:mm:ss


Regards
Claus B.


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Convert seconds to hh:mm:ss?

On Tuesday, November 17, 2015 at 2:00:59 AM UTC+5:30, Terry Pinnell wrote:
Is it possible with a single formula to convert a number of seconds
sssss to the text hh:mm:ss please?

For example, 6185 would become 01:43:05.

--
Terry, East Grinstead, UK


Here you go:

=TEXT(1685/86400,"hh:mm:ss")

Note: Instead of 1685 give cell number for your convenience


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Convert seconds to hh:mm:ss?

On Tuesday, November 17, 2015 at 2:00:59 AM UTC+5:30, Terry Pinnell wrote:
Is it possible with a single formula to convert a number of seconds
sssss to the text hh:mm:ss please?

For example, 6185 would become 01:43:05.

--
Terry, East Grinstead, UK


<<<<<<<

=TEXT(1685/86400,"hh:mm:ss")
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
Need to convert Minutes:Seconds format to minutes with seconds con Cliff Excel Worksheet Functions 3 June 18th 09 05:22 AM
How do I convert 1min and 15 seconds to all seconds bwpate Excel Discussion (Misc queries) 1 March 12th 09 11:03 PM
Convert "Time Interval" in "hours : minutes : seconds" to seconds Ianukotnorth New Users to Excel 7 May 8th 05 08:11 PM
Convert seconds to minutes and seconds in excel anonymous Excel Worksheet Functions 3 December 25th 04 09:38 PM
convert seconds to minutes and seconds Brian Excel Worksheet Functions 2 December 9th 04 10:45 PM


All times are GMT +1. The time now is 11:25 AM.

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"