Results 1 to 5 of 5
  1. #1
    Junior Member
    Join Date
    Dec 2004
    Location
    Christchurch
    Posts
    62

    Default Excel question. Entering times

    Is it possible to enter times in Excel using decimal points as separators instead of colons. I am trying to make a timesheet and it is a pain using the colons
    Athlon Dual Core 2.8GHz, 4GB Ram, Win 7RC, 512 MB Graphics

  2. #2
    Helper < Helped DeSade's Avatar
    Join Date
    Mar 2005
    Location
    Earthquake HQ
    Posts
    3,670

    Default Re: Excel question. Entering times

    Excel doesn't handle time very well Colons are the way to go.

  3. #3
    Member
    Join Date
    Jan 2006
    Location
    Sydney
    Posts
    307

    Default Re: Excel question. Entering times

    not ideal, but why not put the times in using full stops and then when you are done with the times use the Replace function and replace the full stops with colons? Or is the table to be used on an ongoing basis?

  4. #4
    Senior Member
    Join Date
    Dec 2004
    Location
    Wellington, NZ
    Posts
    353

    Default Re: Excel question. Entering times

    While you enter times using a colon, Excel is actually storing this as a number. Days are stored as whole numbers while times are stored as a fraction of a day. For example, enter 08:00 into a cell then go to Format | Cells from the menu and choose the number category. You will see that the number result is 0.33 being 1/3rd of a day.

    Your going to have problems entering using decimals as 8.00 would be considered as 8 days and 0 hours to Excel if you converted this to a time after entering. That said, you could use formulas to convert back to what you require.

    If you dont mind adding a macro to the workbook then Chip Pearsons code may help with quick entry of times... http://www.cpearson.com/excel/DateTimeEntry.htm

    regards,
    Graham

  5. #5
    Junior Member
    Join Date
    Dec 2004
    Location
    Christchurch
    Posts
    62

    Default Re: Excel question. Entering times

    Thanks to all who helped. The macro does the trick
    Athlon Dual Core 2.8GHz, 4GB Ram, Win 7RC, 512 MB Graphics

Similar Threads

  1. Replies: 2
    Last Post: 03-08-2006, 01:28 PM
  2. OT - entering dates into Excel
    By annie in forum PressF1
    Replies: 4
    Last Post: 21-11-2004, 03:27 PM
  3. Replies: 3
    Last Post: 25-07-2002, 08:39 PM
  4. Replies: 0
    Last Post: 08-03-1999, 08:05 PM
  5. Adding Times in Excel
    By in forum PressF1
    Replies: 0
    Last Post: 25-12-1998, 09:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •