| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date and Time (entering in the format of mm/dd/yyyy and hh:mm:ss )
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
| change date format from dd/mm/yyyy to mm/yyyy | Excel Discussion (Misc queries) | |||
| Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y | Excel Discussion (Misc queries) | |||
| Adding date/time in format dd/mm/yyyy hh/mm | Excel Worksheet Functions | |||
| how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
Threaded Mode
