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

    CONVERT DATES FROM EUROPEAN FORMAT TO US FORMAT

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

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

    Epinn, Nov 18, 2006, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    1,884
    Epinn
    Nov 19, 2006
  3. 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:
    404
    Roger Govier
    Feb 9, 2007
  4. ExceLearner

    Convert numbers stored as text to numbers - Automatically - Macro

    ExceLearner, Dec 12, 2012, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    666
    ExceLearner
    Dec 12, 2012
  5. ExceLearner
    Replies:
    0
    Views:
    549
    ExceLearner
    Dec 12, 2012
Loading...

Share This Page