software

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:
gt; I'm trying to track a project over a period of time. Part of that is
gt; to
gt; note the planned date and the actual date and time. In some cases the
gt; task
gt; will take multiple dates and times to complete. I would like to keep
gt; all of
gt; the dates and times in the same cell without converting them to text.
gt; I'm
gt; hoping that this would allow me to use the filters to recognize the
gt; dates
gt; when needed. It would also avoid creating even more columns to track
gt; the
gt; additional dates and times. The same question applies to formulas.
gt; Does
gt; anyone know if what I'm trying to do is even possible. I'm using Excel
gt; 2003
gt; with SP1 to do this work. Thanks for looking into the matter and I
gt; hope to
gt; get a response.
gt; --
gt; PM-S--
rsenn
------------------------------------------------------------------------
rsenn's Profile: www.excelforum.com/member.php...oamp;userid=29050
View this thread: www.excelforum.com/showthread...hreadid=500463Thanks, 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-Squot;rsennquot; wrote:

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