What is ths 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
=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" <[email protected]> wrote in
message news:[email protected]...
> What is ths code to show current hour, minute, and seconds in a cell
Thanks Nigel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks