Number one I am trying to enter time and date so that there will be a lapsed
time shown.

The 1st choice is current time; Formula=NOW() the only problem is it does not show seconds. Is there any way to add seconds to this?
have Current time cell, Start time cell, and an End time cell.
to show lapsed time Example Current minus Start and End minus Start.
In the format of either mm/dd/yyyy and hh:mm:ss AM or mm/dd/yyyy and hh:mm:ss in military time.


Robin

If you're looking for a solution, you need to do one of the following:
1. Keep the conversation in the same thread, or
2. If you start a new thread, then you need to a complete description of
your problem and the solution you want. No one can tell what you're looking
for from just this post.

Regards,
Fred

"Robin" wrote in message
...
Number one I am trying to enter time and date so that there will be a
lapsed
time shown.

The 1st choice is current time; Formula=NOW() the only problem is it does
not show seconds. Is there any way to add seconds to this?
have Current time cell, Start time cell, and an End time cell.
to show lapsed time Example Current minus Start and End minus Start.
In the format of either mm/dd/yyyy and hh:mm:ss AM or mm/dd/yyyy and
hh:mm:ss in military time.


Robin

Thank you. I will try to restate it.

"Fred Smith" wrote:

If you're looking for a solution, you need to do one of the following:
1. Keep the conversation in the same thread, or
2. If you start a new thread, then you need to a complete description of
your problem and the solution you want. No one can tell what you're looking
for from just this post.

Regards,
Fred

"Robin" wrote in message
...
Number one I am trying to enter time and date so that there will be a
lapsed
time shown.

The 1st choice is current time; Formula=NOW() the only problem is it does
not show seconds. Is there any way to add seconds to this?
have Current time cell, Start time cell, and an End time cell.
to show lapsed time Example Current minus Start and End minus Start.
In the format of either mm/dd/yyyy and hh:mm:ss AM or mm/dd/yyyy and
hh:mm:ss in military time.


Robin

I am trying to enter time and date so that there will be a lapsed
time shown.
I would like the time to be shown in the format of mm/dd/yyyy hh:mm:ss AM
or PM in a cell.
1st cell (B6) is current time =NOW() but this does not show seconds. (shows
8/13/09 18:52)
2nd cell (B7) is start time and have entered 8/1/2009 11:00:50 PM (formula
shows correct but when the cell is not clicked in it shows 8/1/2009 23:00)
3rd cell (B8) is end time and have entered 8/21/2009 11:00:58 PM (formula
shows correct but when the cell is not clicked in it shows 8/21/2009 23:00)
4th cell(B9) is Lapsed Time Current-Start entered =B6-B7 which gives value
11.82742604
5th cell(B10) is Lapsed time End - Start B8-B7 which gives a value of
20.00009259
Is there a way to adjust the formulas so that the date and time is in the
format of
mm/dd/yyyy hh:mm:ss AM or PM in a cell. Also if the Now does not show
seconds is the calculation correct for seconds.

"Fred Smith" wrote:

If you're looking for a solution, you need to do one of the following:
1. Keep the conversation in the same thread, or
2. If you start a new thread, then you need to a complete description of
your problem and the solution you want. No one can tell what you're looking
for from just this post.

Regards,
Fred

"Robin" wrote in message
...
Number one I am trying to enter time and date so that there will be a
lapsed
time shown.

The 1st choice is current time; Formula=NOW() the only problem is it does
not show seconds. Is there any way to add seconds to this?
have Current time cell, Start time cell, and an End time cell.
to show lapsed time Example Current minus Start and End minus Start.
In the format of either mm/dd/yyyy and hh:mm:ss AM or mm/dd/yyyy and
hh:mm:ss in military time.


Robin

I am trying to enter time and date so that there will be a lapsed
time shown.
I would like the time to be shown in the format of mm/dd/yyyy hh:mm:ss AM
or PM in a cell.
1st cell (B6) is current time =NOW() but this does not show seconds. (shows
8/13/09 18.52)
2nd cell (B7) is start time and have entered 8/1/2009 11:00:50 PM (formula
shows correct but when the cell is not clicked in it shows 8/1/2009 23:00)
3rd cell (B8) is end time and have entered 8/21/2009 11:00:58 PM (formula
shows correct but when the cell is not clicked in it shows 8/21/2009 23:00)
4th cell(B9) is Lapsed Time Current-Start entered =B6-B7 which gives value
11.82742604
5th cell(B10) is Lapsed time End - Start B8-B7 which gives a value of
20.00009259
Is there a way to adjust the formulas so that the date and time is in the
format of
mm/dd/yyyy hh:mm:ss AM or PM in a cell. Also if the Now does not show
seconds is the calculation correct for seconds.




If you're looking for a solution, you need to do one of the following:
1. Keep the conversation in the same thread, or
2. If you start a new thread, then you need to a complete description of
your problem and the solution you want. No one can tell what you're looking
for from just this post.

Regards,
Fred

"Robin" wrote in message
...
Number one I am trying to enter time and date so that there will be a
lapsed
time shown.

The 1st choice is current time; Formula=NOW() the only problem is it does
not show seconds. Is there any way to add seconds to this?
have Current time cell, Start time cell, and an End time cell.
to show lapsed time Example Current minus Start and End minus Start.
In the format of either mm/dd/yyyy and hh:mm:ss AM or mm/dd/yyyy and
hh:mm:ss in military time.


Robin

From what I can see, you just need to format your cells the way you want.
=now() doesn't show seconds initially, but they are there. Just change the
format to:
mm/dd/yyyy hh:mm:ss

Same with your calculation result. You likely want something like:
dd hh:mm:ss

If your elapsed time is more than 31 days, Excel won't go past that, so post
back if you need a solution for this.

Regards,
Fred

"Robin" wrote in message
...
I am trying to enter time and date so that there will be a lapsed
time shown.
I would like the time to be shown in the format of mm/dd/yyyy hh:mm:ss AM
or PM in a cell.
1st cell (B6) is current time =NOW() but this does not show seconds.
(shows
8/13/09 18.52)
2nd cell (B7) is start time and have entered 8/1/2009 11:00:50 PM
(formula
shows correct but when the cell is not clicked in it shows 8/1/2009 23:00)
3rd cell (B8) is end time and have entered 8/21/2009 11:00:58 PM (formula
shows correct but when the cell is not clicked in it shows 8/21/2009
23:00)
4th cell(B9) is Lapsed Time Current-Start entered =B6-B7 which gives value
11.82742604
5th cell(B10) is Lapsed time End - Start B8-B7 which gives a value of
20.00009259
Is there a way to adjust the formulas so that the date and time is in the
format of
mm/dd/yyyy hh:mm:ss AM or PM in a cell. Also if the Now does not show
seconds is the calculation correct for seconds.




If you're looking for a solution, you need to do one of the following:
1. Keep the conversation in the same thread, or
2. If you start a new thread, then you need to a complete description of
your problem and the solution you want. No one can tell what you're
looking
for from just this post.

Regards,
Fred

"Robin" wrote in message
...
Number one I am trying to enter time and date so that there will be a
lapsed
time shown.

The 1st choice is current time; Formula=NOW() the only problem is it
does
not show seconds. Is there any way to add seconds to this?
have Current time cell, Start time cell, and an End time cell.
to show lapsed time Example Current minus Start and End minus Start.
In the format of either mm/dd/yyyy and hh:mm:ss AM or mm/dd/yyyy and
hh:mm:ss in military time.


Robin

I have tried to format the cells the way that I want.
Is there a specific order that is needed to format the cells for the date
and time in mm/dd/yyyy and hh:mm:ss? I must be missing something?
So are you saying that even though they are not seen it is calculating
properly.
Why is the subtraction of current and start , and end and start represented
with a decimal instead of the true seconds?
The Days could be over 31 so I would need help with this.

Robin

"Fred Smith" wrote:

From what I can see, you just need to format your cells the way you want.
=now() doesn't show seconds initially, but they are there. Just change the
format to:
mm/dd/yyyy hh:mm:ss

Same with your calculation result. You likely want something like:
dd hh:mm:ss

If your elapsed time is more than 31 days, Excel won't go past that, so post
back if you need a solution for this.

Regards,
Fred

"Robin" wrote in message
...
I am trying to enter time and date so that there will be a lapsed
time shown.
I would like the time to be shown in the format of mm/dd/yyyy hh:mm:ss AM
or PM in a cell.
1st cell (B6) is current time =NOW() but this does not show seconds.
(shows
8/13/09 18.52)
2nd cell (B7) is start time and have entered 8/1/2009 11:00:50 PM
(formula
shows correct but when the cell is not clicked in it shows 8/1/2009 23:00)
3rd cell (B8) is end time and have entered 8/21/2009 11:00:58 PM (formula
shows correct but when the cell is not clicked in it shows 8/21/2009
23:00)
4th cell(B9) is Lapsed Time Current-Start entered =B6-B7 which gives value
11.82742604
5th cell(B10) is Lapsed time End - Start B8-B7 which gives a value of
20.00009259
Is there a way to adjust the formulas so that the date and time is in the
format of
mm/dd/yyyy hh:mm:ss AM or PM in a cell. Also if the Now does not show
seconds is the calculation correct for seconds.




If you're looking for a solution, you need to do one of the following:
1. Keep the conversation in the same thread, or
2. If you start a new thread, then you need to a complete description of
your problem and the solution you want. No one can tell what you're
looking
for from just this post.

Regards,
Fred

"Robin" wrote in message
...
Number one I am trying to enter time and date so that there will be a
lapsed
time shown.

The 1st choice is current time; Formula=NOW() the only problem is it
does
not show seconds. Is there any way to add seconds to this?
have Current time cell, Start time cell, and an End time cell.
to show lapsed time Example Current minus Start and End minus Start.
In the format of either mm/dd/yyyy and hh:mm:ss AM or mm/dd/yyyy and
hh:mm:ss in military time.


Robin

Let's get the formatting down first.

Enter =now() in an empty cell.
Right-click on the cell, choose Format Cells...
Based on your post, you should see
mm/dd/yyyy hh:mm
in the Type: box
Add the :ss to the format.

Does this now display the date/time the way you want?
If so, copy this format to your other cells.

Regards,
Fred

"Robin" wrote in message
...
I have tried to format the cells the way that I want.
Is there a specific order that is needed to format the cells for the date
and time in mm/dd/yyyy and hh:mm:ss? I must be missing something?
So are you saying that even though they are not seen it is calculating
properly.
Why is the subtraction of current and start , and end and start
represented
with a decimal instead of the true seconds?
The Days could be over 31 so I would need help with this.

Robin

"Fred Smith" wrote:

From what I can see, you just need to format your cells the way you want.
=now() doesn't show seconds initially, but they are there. Just change
the
format to:
mm/dd/yyyy hh:mm:ss

Same with your calculation result. You likely want something like:
dd hh:mm:ss

If your elapsed time is more than 31 days, Excel won't go past that, so
post
back if you need a solution for this.

Regards,
Fred

"Robin" wrote in message
...
I am trying to enter time and date so that there will be a lapsed
time shown.
I would like the time to be shown in the format of mm/dd/yyyy hh:mm:ss
AM
or PM in a cell.
1st cell (B6) is current time =NOW() but this does not show seconds.
(shows
8/13/09 18.52)
2nd cell (B7) is start time and have entered 8/1/2009 11:00:50 PM
(formula
shows correct but when the cell is not clicked in it shows 8/1/2009
23:00)
3rd cell (B8) is end time and have entered 8/21/2009 11:00:58 PM
(formula
shows correct but when the cell is not clicked in it shows 8/21/2009
23:00)
4th cell(B9) is Lapsed Time Current-Start entered =B6-B7 which gives
value
11.82742604
5th cell(B10) is Lapsed time End - Start B8-B7 which gives a value of
20.00009259
Is there a way to adjust the formulas so that the date and time is in
the
format of
mm/dd/yyyy hh:mm:ss AM or PM in a cell. Also if the Now does not show
seconds is the calculation correct for seconds.




If you're looking for a solution, you need to do one of the
following:
1. Keep the conversation in the same thread, or
2. If you start a new thread, then you need to a complete description
of
your problem and the solution you want. No one can tell what you're
looking
for from just this post.

Regards,
Fred

"Robin" wrote in message
...
Number one I am trying to enter time and date so that there will be
a
lapsed
time shown.

The 1st choice is current time; Formula=NOW() the only problem is it
does
not show seconds. Is there any way to add seconds to this?
have Current time cell, Start time cell, and an End time cell.
to show lapsed time Example Current minus Start and End minus
Start.
In the format of either mm/dd/yyyy and hh:mm:ss AM or mm/dd/yyyy
and
hh:mm:ss in military time.


Robin