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

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

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

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.

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

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")