Code to show current hour minute and seconds in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
=Now
Format the cell to required time eg "hh:mm:ss"
The cell is volatile - that is when the sheet is re-calculated the cell
changes to the current system time
 
Back
Top