Code to show current hour minute and seconds in a cell
 

What is ths code to show current hour, minute, and seconds in a cell

Code to show current hour minute and seconds in a cell
 

=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

--
Cheers
Nigel



"Dr.H.Subramanian" wrote in
message ...
What is ths code to show current hour, minute, and seconds in a cell

Code to show current hour minute and seconds in a cell
 

Thanks Nigel