Time function in Excel

  • Thread starter Thread starter Ian M
  • Start date Start date
I

Ian M

How can I programme an individual cell in an Excel spreadsheet to
perform a task depending on what time is entered into it.

i.e. if any time is entered which falls between 12.00 noon and 1.30
pm, I want a message box to appear saying "Remember to Order Lunch".

Any ideas?

Thanks for your help.

Kind regards

Paddymichelle
 
if time >= TimeValue("12:00 PM") or time <= TimeValue("1:00 PM") then
 
You must log in or register to reply here.

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

Excel Time Rounding in Excel 2
Finding and replacing characters in Excel 2
How to enter start and end date/time in excel based on some specific value. 7
Time Formating 2
Excel Multiple If True Values - IF Function Excel 0
Cut & Paste in Excel without erasing cell borders? 1
Excel Excel IF variable based on time of day 0
'.Copy Destination:=' temporarily freezes multiple instances in Excel 2010 2

Back
Top