how to get current time

I need a function that shows current time in a cell when I open a spreadsheet.

It’s =NOW(), formatted to show only time.