+ Reply to Thread
Results 1 to 3 of 3

Code to show current hour minute and seconds in a cell

  1. #1
    Dr.H.Subramanian
    Guest

    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

  2. #2
    Nigel
    Guest

    Re: 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




  3. #3
    Dr.H.Subramanian
    Guest

    Re: Code to show current hour minute and seconds in a cell

    Thanks Nigel



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1