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

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

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