Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default formula to insert time of day in excel cell

How Can I set up an excel sheet to track time so that when I click on the
designated excel cell it automatically inserts time of the day
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default formula to insert time of day in excel cell


novice123,

You can use the Worksheet_SelectionChange Event.

What is the sheetname?

What is the cell (A1, B10)?

What time format do you want displayed (hh:mm:ss, ...)?


--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115152

Reply
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
formula to insert time of day in excel cell novice 123 Excel Worksheet Functions 1 July 11th 09 11:53 PM
formula to insert time of day in excel cell novice567 Excel Discussion (Misc queries) 1 July 11th 09 11:17 PM
formula to insert time of day in excel cell novice 123 Excel Worksheet Functions 0 July 11th 09 11:03 PM
Insert newline in cell through formula (excel 2003) Bart Wouters Excel Worksheet Functions 2 July 23rd 07 04:04 PM
automatically insert system time in a cell PM Excel Discussion (Misc queries) 2 December 30th 04 04:56 PM


All times are GMT +1. The time now is 07:23 PM.

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

About Us

"It's about Microsoft Excel"