Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter text automatically based on current time
I have a read-only spreadsheet that's used twice on a daily basis. Text is
entered in the morning and in the afternoon. I was trying to come up with a formula to ease some of this routine text-entering. Specifically, is it possible for Excel to enter "Some Text 1" into an empty cell, provided the file is opened when the current time is AM, and "Some Text 2" when the file is opened when the current time is PM? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter text automatically based on current time
=IF(MOD(NOW(),1)<0.5,"Some Text 1","Some Text 2")
If you want the text to stay after the initial entry, copy, and paste special/ values. -- David Biddulph "jmj713" wrote in message ... I have a read-only spreadsheet that's used twice on a daily basis. Text is entered in the morning and in the afternoon. I was trying to come up with a formula to ease some of this routine text-entering. Specifically, is it possible for Excel to enter "Some Text 1" into an empty cell, provided the file is opened when the current time is AM, and "Some Text 2" when the file is opened when the current time is PM? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter text automatically based on current time
Thanks so much! You have saved us some time with this.
"David Biddulph" wrote: =IF(MOD(NOW(),1)<0.5,"Some Text 1","Some Text 2") If you want the text to stay after the initial entry, copy, and paste special/ values. -- David Biddulph "jmj713" wrote in message ... I have a read-only spreadsheet that's used twice on a daily basis. Text is entered in the morning and in the afternoon. I was trying to come up with a formula to ease some of this routine text-entering. Specifically, is it possible for Excel to enter "Some Text 1" into an empty cell, provided the file is opened when the current time is AM, and "Some Text 2" when the file is opened when the current time is PM? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter text automatically based on current time
You could use a formula kind of like this...
=IF(MOD(NOW(),1)<=0.5, "AM", "PM") -- HTH... Jim Thomlinson "jmj713" wrote: I have a read-only spreadsheet that's used twice on a daily basis. Text is entered in the morning and in the afternoon. I was trying to come up with a formula to ease some of this routine text-entering. Specifically, is it possible for Excel to enter "Some Text 1" into an empty cell, provided the file is opened when the current time is AM, and "Some Text 2" when the file is opened when the current time is PM? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter current date automatically in filename | Excel Worksheet Functions | |||
Can Excel automatically enter the current date in a spreadsheet? | Excel Discussion (Misc queries) | |||
Can I automatically enter the current date or current time into a | New Users to Excel | |||
How to enter current static time in Excel in 00:00:00.0 format? | Excel Worksheet Functions | |||
sum automatically from last 12 months based on current date | Excel Worksheet Functions |