LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
external usenet poster
 
Posts: 6
Default In Excel: is there a way of inserting the current time (what time it is right NOW)



This would help me save time


Everytime I take a pill (medication) I jot down the time.

In Word, it is easy. You just select Insert--Date/Time & then select
the current time (without auto-update)


Is there an equivalent command in Excel?


In Excel I have time-sheets for work. I jot down the time it is when I
arrive at work/uni etc. It would be useful if I could just click a
button and it would insert the current time. (I know it's not hard to
just type in 9:05am, but anything that saves time is a bonus!)

 
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
Excel: How to insert current time (static) to the nearest second? gwm Excel Worksheet Functions 14 July 13th 07 12:26 AM
Having the current time inserted w/o updating the current time sherobot Excel Worksheet Functions 2 October 2nd 06 05:05 PM
Determining current Time Zone In Excel Shaun_C Excel Discussion (Misc queries) 2 April 7th 06 06:29 PM
Can I automatically enter the current date or current time into a Ben New Users to Excel 7 October 19th 05 03:38 PM
How to enter current static time in Excel in 00:00:00.0 format? Wlumkong Excel Worksheet Functions 3 May 12th 05 03:54 PM


All times are GMT +1. The time now is 10:03 PM.

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"