Insert current system date and time
Is there a way I can get Numbers to enter the current system date and time in a cell? When I am actually in the cell, I can use the menu Insert:Date and Time to insert the current system date. But it always writes the time as midnight. I need it to write weaver the current time actually is.
I've tried custom formatting, which it ignores in this process, and every other format that I've been able to think of via the Cell:Data Format panel.
Thanks much!
MacBook Pro 15″, macOS 10.15