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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
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:
    3,128
    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:
    398
    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:
    442
    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:
    3,029
    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:
    523
    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:
    510
    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:
    825
    ExceLearner
    Dec 12, 2012
  8. ExceLearner
    Replies:
    0
    Views:
    664
    ExceLearner
    Dec 12, 2012
Loading...