Forum Discussion
short cut entering time incl. the seconds
Hi Team, i am looking now since hours for an option to enter the actuel time incl. the seconds. hh:mm:ss. The cell is formated like this. Entering the time with strg+shift+. only enters hh:mm and sh...
Another option seems to be to use data validation. The validation list would comprise a single cell containing
= MOD(NOW(),1)maybe with number formatting so that the dropdown list shows "insert current time".
- PeterBartholomew1 thank you also!! I will try tomorrow when i am back in the office.
