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