PC Review


Reply
Thread Tools Rate Thread

Convert real number to an h:mm:ss display

 
 
Tom Weyand
Guest
Posts: n/a
 
      22nd Feb 2006
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.

--


 
Reply With Quote
 
 
 
 
Fred Smith
Guest
Posts: n/a
 
      22nd Feb 2006
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.
>
> --
>
>



 
Reply With Quote
 
Tom Weyand
Guest
Posts: n/a
 
      22nd Feb 2006
Worked just fine, thanks


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


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