Show dynamic time (and not date) in excel

try this formula

=NOW()-TRUNC(NOW())

=NOW()-TODAY()

After you entered the formual =now() to the cell, select the cell and press Ctrl + Shift + 2 You're welcome!

=Now()

1. Right Click on Cell
2. Click Format Cells
3. Click on Custom on left side
4. Select the time format as h:mm:ss AM/PM
5. Click OK

One more Solution:-

=TEXT(NOW(), "hh:mm:ss AM/PM")