+ Reply to Thread
Results 1 to 3 of 3

Multiple dates, times, or formulas in a single cell

  1. #1
    PM-S
    Guest

    Multiple dates, times, or formulas in a single cell

    I'm trying to track a project over a period of time. Part of that is to
    note the planned date and the actual date and time. In some cases the task
    will take multiple dates and times to complete. I would like to keep all of
    the dates and times in the same cell without converting them to text. I'm
    hoping that this would allow me to use the filters to recognize the dates
    when needed. It would also avoid creating even more columns to track the
    additional dates and times. The same question applies to formulas. Does
    anyone know if what I'm trying to do is even possible. I'm using Excel 2003
    with SP1 to do this work. Thanks for looking into the matter and I hope to
    get a response.
    --
    PM-S

  2. #2
    Registered User
    Join Date
    11-23-2005
    Posts
    70
    Sorry, but if you put multiple dates in a cell then Excel will likely see them as text. Excel stores dates as numbers, such as 38730, so you might be able to get fancy with the numbers such as 38730.38731 to store two dates, if you put formulas elsewhere to break them out in some meaningful fashion.

    You might consider arranging all your data in a table so that a task that if a task takes multiple dates and times to complete it is treated as two tasks.


    Quote Originally Posted by PM-S
    I'm trying to track a project over a period of time. Part of that is to
    note the planned date and the actual date and time. In some cases the task
    will take multiple dates and times to complete. I would like to keep all of
    the dates and times in the same cell without converting them to text. I'm
    hoping that this would allow me to use the filters to recognize the dates
    when needed. It would also avoid creating even more columns to track the
    additional dates and times. The same question applies to formulas. Does
    anyone know if what I'm trying to do is even possible. I'm using Excel 2003
    with SP1 to do this work. Thanks for looking into the matter and I hope to
    get a response.
    --
    PM-S

  3. #3
    PM-S
    Guest

    Re: Multiple dates, times, or formulas in a single cell

    Thanks, rsenn. I don't know much about Excel tables but this is as good a
    time as any to learn about them. Do you know if the same thing would apply
    to formulas?
    --
    PM-S


    "rsenn" wrote:

    >
    > Sorry, but if you put multiple dates in a cell then Excel will likely
    > see them as text. Excel stores dates as numbers, such as 38730, so you
    > might be able to get fancy with the numbers such as 38730.38731 to store
    > two dates, if you put formulas elsewhere to break them out in some
    > meaningful fashion.
    >
    > You might consider arranging all your data in a table so that a
    > task that if a task takes multiple dates and times to complete it is
    > treated as two tasks.
    >
    >
    > PM-S Wrote:
    > > I'm trying to track a project over a period of time. Part of that is
    > > to
    > > note the planned date and the actual date and time. In some cases the
    > > task
    > > will take multiple dates and times to complete. I would like to keep
    > > all of
    > > the dates and times in the same cell without converting them to text.
    > > I'm
    > > hoping that this would allow me to use the filters to recognize the
    > > dates
    > > when needed. It would also avoid creating even more columns to track
    > > the
    > > additional dates and times. The same question applies to formulas.
    > > Does
    > > anyone know if what I'm trying to do is even possible. I'm using Excel
    > > 2003
    > > with SP1 to do this work. Thanks for looking into the matter and I
    > > hope to
    > > get a response.
    > > --
    > > PM-S

    >
    >
    > --
    > rsenn
    > ------------------------------------------------------------------------
    > rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
    > View this thread: http://www.excelforum.com/showthread...hreadid=500463
    >
    >


+ 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