+ Reply to Thread
Results 1 to 3 of 3

Changing a cells format (Time)

  1. #1
    Keith
    Guest

    Changing a cells format (Time)

    I have a large list of times. There are in fact how long a call lasts.
    Unfortunatly they are in the wron format. The format is 00:00:00 hours,
    minutes, seconds.

    I have changed their format to time, but when I sum them I get 00:00:00 as
    the result.

    But if I double click on a cell then click off it again the formatting
    changes. The entries go from being left justified to right and the sum
    function now works. In the undo drop down it say it wants to undo Typing
    '0:01:03' in N4 for example.

    How can I do this automaticaly because I have about 12,000 entries?

  2. #2
    David Biddulph
    Guest

    Re: Changing a cells format (Time)

    "Keith" <Keith@discussions.microsoft.com> wrote in message
    news:4170FAC2-C590-47B1-AC8B-DC5E094C9B03@microsoft.com...
    >I have a large list of times. There are in fact how long a call lasts.
    > Unfortunatly they are in the wron format. The format is 00:00:00 hours,
    > minutes, seconds.
    >
    > I have changed their format to time, but when I sum them I get 00:00:00 as
    > the result.
    >
    > But if I double click on a cell then click off it again the formatting
    > changes. The entries go from being left justified to right and the sum
    > function now works. In the undo drop down it say it wants to undo Typing
    > '0:01:03' in N4 for example.
    >
    > How can I do this automaticaly because I have about 12,000 entries?


    Having changed the format of the cells from text to time, put a zero in a
    spare cell, copy, select the range of your cells, then paste special/ add.
    --
    David Biddulph



  3. #3
    Keith
    Guest

    Re: Changing a cells format (Time)

    David,

    Your a life saver.

    Thanks a lot. It works. Fantastic

    "David Biddulph" wrote:

    > "Keith" <Keith@discussions.microsoft.com> wrote in message
    > news:4170FAC2-C590-47B1-AC8B-DC5E094C9B03@microsoft.com...
    > >I have a large list of times. There are in fact how long a call lasts.
    > > Unfortunatly they are in the wron format. The format is 00:00:00 hours,
    > > minutes, seconds.
    > >
    > > I have changed their format to time, but when I sum them I get 00:00:00 as
    > > the result.
    > >
    > > But if I double click on a cell then click off it again the formatting
    > > changes. The entries go from being left justified to right and the sum
    > > function now works. In the undo drop down it say it wants to undo Typing
    > > '0:01:03' in N4 for example.
    > >
    > > How can I do this automaticaly because I have about 12,000 entries?

    >
    > Having changed the format of the cells from text to time, put a zero in a
    > spare cell, copy, select the range of your cells, then paste special/ add.
    > --
    > David Biddulph
    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1