Convert time stored as decimalised number to time format

Discussion in 'Microsoft Excel New Users' started by Emma, Apr 29, 2008.

  1. Emma

    Emma Guest

    Hello
    How can I convert 3.5 hours to 3:30:00?
    --
    Emma
     
    Emma, Apr 29, 2008
    #1
    1. Advertisements

  2. Emma

    Mike Rogers Guest

    Emma

    A1/24 and formate as time

    Mike Rogers

    "Emma" wrote:

    > Hello
    > How can I convert 3.5 hours to 3:30:00?
    > --
    > Emma
     
    Mike Rogers, Apr 29, 2008
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    How do I format a number in a currency format in word

    Guest, Sep 14, 2004, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    2,208
    Dave Peterson
    Sep 15, 2004
  2. Scot

    Change number format from text to number?

    Scot, Dec 1, 2005, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    354
    gls858
    Dec 1, 2005
  3. Guest

    CONVERT DATES FROM EUROPEAN FORMAT TO US FORMAT

    Guest, Aug 8, 2006, in forum: Microsoft Excel New Users
    Replies:
    8
    Views:
    389
    Guest
    Aug 8, 2006
  4. Epinn

    How to convert fraction format to text format ......

    Epinn, Nov 18, 2006, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    2,357
    Epinn
    Nov 19, 2006
  5. Guest

    how will i convert 05.01.2007 convert 05.Jan.2007 format?

    Guest, Feb 8, 2007, in forum: Microsoft Excel New Users
    Replies:
    17
    Views:
    478
    Roger Govier
    Feb 9, 2007
  6. Walter

    replacing FIRST NUMBER-SECOND NUMBER with SECOND NUMBER

    Walter, Feb 23, 2008, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    444
    Walter
    Feb 24, 2008
  7. ExceLearner

    Convert numbers stored as text to numbers - Automatically - Macro

    ExceLearner, Dec 12, 2012, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    791
    ExceLearner
    Dec 12, 2012
  8. ExceLearner
    Replies:
    0
    Views:
    621
    ExceLearner
    Dec 12, 2012
Loading...