LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
AussieAVguy
 
Posts: n/a
Default How do I automaticly insert the time with seconds

I need to be able to have excel insert the current time including seconds
into a cell. I've tried the Now() function but it keeps updating everytime
the spreadsheet recalculates. The shortcut ctrl+shift+; doesn't give seconds
and I'd prefer it to happen automaticly.

Anyone??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting Time with Hundredths of Seconds quebro5 Excel Worksheet Functions 1 May 5th 05 03:16 AM
how do i insert the current time into a cell, and show different . Dave Excel Discussion (Misc queries) 1 March 22nd 05 06:57 PM
static time including seconds Kaedo Excel Worksheet Functions 1 February 9th 05 06:38 PM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 06:57 PM
The shortcut to enter time in excel should include seconds. JoeGill Excel Discussion (Misc queries) 3 January 9th 05 08:02 PM


All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"