+ Reply to Thread
Results 1 to 7 of 7

Running/Current time in cell?

  1. #1
    SRS
    Guest

    Running/Current time in cell?

    I know that if I enter CTRL+SHIFT; it will enter the current time of day.

    But...is there any formula out there that will insert the time of day and
    keep it current? (Basically a running clock, so that whenever the
    spreadsheet is open, cell A1 (for example) will always show the current
    time???)

    Just wondering........

  2. #2
    Anne Troy
    Guest

    Re: Running/Current time in cell?

    Just type =Now() into the cell.
    ************
    Anne Troy
    www.OfficeArticles.com

    "SRS" <[email protected]> wrote in message
    news:[email protected]...
    >I know that if I enter CTRL+SHIFT; it will enter the current time of day.
    >
    > But...is there any formula out there that will insert the time of day and
    > keep it current? (Basically a running clock, so that whenever the
    > spreadsheet is open, cell A1 (for example) will always show the current
    > time???)
    >
    > Just wondering........




  3. #3
    George Gee
    Guest

    Re: Running/Current time in cell?

    =NOW()

    George Gee


    SRS wrote:
    > I know that if I enter CTRL+SHIFT; it will enter the current time of
    > day.
    >
    > But...is there any formula out there that will insert the time of day
    > and keep it current? (Basically a running clock, so that whenever the
    > spreadsheet is open, cell A1 (for example) will always show the
    > current time???)
    >
    > Just wondering........




  4. #4
    George Gee
    Guest

    Re: Running/Current time in cell?

    SRS

    If you wish to display the time only, without the date:
    Format ? Cells > Number tab > highlight 'Time'
    on the left, and make your choice from the right.

    HTH

    George Gee



    SRS wrote:
    > I know that if I enter CTRL+SHIFT; it will enter the current time of
    > day.
    >
    > But...is there any formula out there that will insert the time of day
    > and keep it current? (Basically a running clock, so that whenever the
    > spreadsheet is open, cell A1 (for example) will always show the
    > current time???)
    >
    > Just wondering........




  5. #5
    Gord Dibben
    Guest

    Re: Running/Current time in cell?

    Which will update only when calculation takes place.

    Or do you actually want to see the seconds ticking by?

    Would take VBA and resources to have that occur.


    Gord Dibben Excel MVP


    On Wed, 28 Sep 2005 16:17:00 -0400, "Anne Troy" <[email protected]> wrote:

    >Just type =Now() into the cell.
    >************
    >Anne Troy
    >www.OfficeArticles.com
    >
    >"SRS" <[email protected]> wrote in message
    >news:[email protected]...
    >>I know that if I enter CTRL+SHIFT; it will enter the current time of day.
    >>
    >> But...is there any formula out there that will insert the time of day and
    >> keep it current? (Basically a running clock, so that whenever the
    >> spreadsheet is open, cell A1 (for example) will always show the current
    >> time???)
    >>
    >> Just wondering........

    >



  6. #6
    SRS
    Guest

    Re: Running/Current time in cell?

    Anne & George:
    Thank you!

    "George Gee" wrote:

    > =NOW()
    >
    > George Gee
    >
    >
    > SRS wrote:
    > > I know that if I enter CTRL+SHIFT; it will enter the current time of
    > > day.
    > >
    > > But...is there any formula out there that will insert the time of day
    > > and keep it current? (Basically a running clock, so that whenever the
    > > spreadsheet is open, cell A1 (for example) will always show the
    > > current time???)
    > >
    > > Just wondering........

    >
    >
    >


  7. #7
    SRS
    Guest

    Re: Running/Current time in cell?

    Thank you for clarifying...I have no clue about VBA (remember, this forum is
    titled "New User" ..... so the =NOW() formula will work for now.

    Thanks to all for such quick help!

    "Gord Dibben" wrote:

    > Which will update only when calculation takes place.
    >
    > Or do you actually want to see the seconds ticking by?
    >
    > Would take VBA and resources to have that occur.
    >
    >
    > Gord Dibben Excel MVP
    >
    >
    > On Wed, 28 Sep 2005 16:17:00 -0400, "Anne Troy" <[email protected]> wrote:
    >
    > >Just type =Now() into the cell.
    > >************
    > >Anne Troy
    > >www.OfficeArticles.com
    > >
    > >"SRS" <[email protected]> wrote in message
    > >news:[email protected]...
    > >>I know that if I enter CTRL+SHIFT; it will enter the current time of day.
    > >>
    > >> But...is there any formula out there that will insert the time of day and
    > >> keep it current? (Basically a running clock, so that whenever the
    > >> spreadsheet is open, cell A1 (for example) will always show the current
    > >> time???)
    > >>
    > >> Just wondering........

    > >

    >
    >


+ 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