Convert real number to an h:mm:ss display

's Computer Specifications

Let's say I have a real number, i.e. 123456.789, that is in seconds and I
want to display it as 34:17:37. I kinda got lost trying to use
TEXT(TIME(etc.)). Maybe there is a better way.

--

's Computer Specifications

Excel stores times as fractions of a day. So change your seconds into days with:

=a1/86400

Format the result as [h]:mm:ss so that it will display more than 24 hours.

--
Regards,
Fred

"Tom Weyand" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Let's say I have a real number, i.e. 123456.789, that is in seconds and I want
> to display it as 34:17:37. I kinda got lost trying to use TEXT(TIME(etc.)).
> Maybe there is a better way.
>
> --
>
>

's Computer Specifications

Worked just fine, thanks

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Number of files on the machine appears TWICE the real number	Stevie M	Windows XP Help	4	4th Dec 2009 03:52 PM
convert [h]:mm:ss to real number that I can use as a multiplier	Dean	Microsoft Excel Worksheet Functions	3	2nd May 2009 08:52 PM
Real Free SW to convert MP3 to WMA	Taf®	Freeware	6	23rd Dec 2005 10:41 PM
convert real audion to mp3	Ian Hurst (Troyka)	Freeware	3	21st Feb 2004 01:25 PM
Convert string to real number	Jason Frazer	Microsoft Access Form Coding	3	10th Nov 2003 05:36 PM