Enter text automatically based on current time

G

Guest

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?
 
D

David Biddulph

=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
if/then insert date but don't want automatic updates 7
Excel Time Formula 4
Formula for time, possible? 5
Time format 10
entering current time in shared work book - 2003 1
Trying to run excel vba code when cell value changes from empty to entered value. 1
Excel Macro for time "Excel 2003" 2

Top