Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to replace a constant from a cell containing date and time
In the below example the number in the bracket is the no of days elapsed from the date given in the cell till today. this is a software generated report which shows the aging. i want to take only the no of days. i want to replace date and time. please help me to do so. Below it shows the date and time the data was entered to the software and the no of days elapsed.
2012-05-21 08:11:42( 135) Thankyou |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text in a cell invoke constant date in another cell - how | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions |