Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
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!) |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
In Excel: is there a way of inserting the current time (what time it is right NOW)
Control semi-colon inserts the date.
Control shift colon inserts the time. -- David Biddulph wrote in message ups.com... 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!) |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
In Excel: is there a way of inserting the current time (what time it is right NOW)
On May 20, 9:16 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote: Control semi-colon inserts the date. Control shift colon inserts the time. -- David Biddulph No way? ! Just tried it on the Mac - Command -semicolon works!!! thank you so much - I never knew that! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I highlight a row in Excel based on the current time? | Excel Discussion (Misc queries) | |||
In Excel: is there a way of inserting the current time (what time it is right NOW) | Excel Discussion (Misc queries) | |||
Having the current time inserted w/o updating the current time | Excel Worksheet Functions | |||
Determining current Time Zone In Excel | Excel Discussion (Misc queries) | |||
Can I automatically enter the current date or current time into a | New Users to Excel |