Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time value
Hi,
Is it possible to get the time value while entering data. for example when i enter data(date) at 2.00 pm, the cell(same cell or in a different cell) should capture the time of data entry. And it should be static. so that in future i can know the time of data entry Thanks in advance for help. Jithu |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time value
Press and hold the Ctrl key while you pess the semi-colon key ; then,
(without the Ctrl key being pressed) , enter a space then press and hold both Ctrl & Shift while you press the full colon key : This will enter the date then the time as a static entry. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Jithu" wrote in message ... Hi, Is it possible to get the time value while entering data. for example when i enter data(date) at 2.00 pm, the cell(same cell or in a different cell) should capture the time of data entry. And it should be static. so that in future i can know the time of data entry Thanks in advance for help. Jithu |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time value
"Sandy Mann" wrote: Press and hold the Ctrl key while you pess the semi-colon key ; then, (without the Ctrl key being pressed) , enter a space then press and hold both Ctrl & Shift while you press the full colon key : This will enter the date then the time as a static entry. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Jithu" wrote in message ... Hi, Is it possible to get the time value while entering data. for example when i enter data(date) at 2.00 pm, the cell(same cell or in a different cell) should capture the time of data entry. And it should be static. so that in future i can know the time of data entry Thanks in advance for help. Jithu |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions |