software

Hi,

I need to know how to change 84587 seconds in hh:mm:ss.
I try 84587/60 and I got 1409.7833
What's the right thing that I must do ??

It's a good question this one. Presume you have the number of seconds
to convert in cell N13 then put this formula in cell N14

=INT(N13/3600)amp;quot;:quot;amp;INT(((N13/3600)-INT(N13/3600))*60)amp;quot;:quot;amp;INT((((N13/3600)-INT(N13/3600))*60-INT(((N13/3600)-INT(N13/3600))*60))*60)

I imagine this could be done more succinctly, I'd be interested to see
other answers.

HTH=A1/24/60/60

Format as Time

--
Kind regards,

Niek Ottenquot;Xaviequot; gt; wrote in message ...
gt; Hi,
gt;
gt; I need to know how to change 84587 seconds in hh:mm:ss.
gt; I try 84587/60 and I got 1409.7833
gt; What's the right thing that I must do ??
Thanks, it works.

Do you know what formula can I use to multiply these minute to amount ??
I have 1:54:30*2.18

What's the right way to do it ?

quot;chillihawkquot; wrote:

gt; It's a good question this one. Presume you have the number of seconds
gt; to convert in cell N13 then put this formula in cell N14
gt;
gt; =INT(N13/3600)amp;quot;:quot;amp;INT(((N13/3600)-INT(N13/3600))*60)amp;quot;:quot;amp;INT((((N13/3600)-INT(N13/3600))*60-INT(((N13/3600)-INT(N13/3600))*60))*60)
gt;
gt; I imagine this could be done more succinctly, I'd be interested to see
gt; other answers.
gt;
gt; HTH
gt;
gt;