³How do I display time in a spreadsheet, I want the format to be Hours,
minutes, seconds am/pm, example 3:15:59 PM

The problem is that I want that cell to be dynamic and updating, anytime
that spreadsheet is open, and is it also possible to have it constantly
updating?

I know how to insert the current time, and update the field, However I want
to display the time field as a dynamic digital clock, referenced to my
computer time.²

Thanks