If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Record time by formula
Just to add...
When I want to include the date and time in the cell, I use: ctrl-;(spacecharacter)ctrl-: FSt1 wrote: hi there is no formula that will display the time that is not volital meaning that it is keyed to the system clock and will update to the current time each time the sheet calculates formulas. the keyboard shortcut Ctrl + Shift + : will insert the current time(system clock) into a selected cell but that is a manual process. if that is not what you want, vb is about all that is left. Regards FSt1 "karim" wrote: hi, i want to create excel sheet wherein time has to be recorded multiple time. Now() formula does not help and i don't want to use macro. Pls Suggest -- Dave Peterson |
|
Thread Tools | |
Display Modes | |
|
|