View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Date and Time (entering in the format of mm/dd/yyyy and hh:mm:ss )

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