Multiple Time Range Conditional
 

I have put the running time on a worksheet. I want to reference that time
and for 6 time ranges during the day, I want to display a message to the user
via text in a cell. How do I reference these time ranges and how do I
display this message only during these 6 time ranges?

Thanks!

Multiple Time Range Conditional
 

Can you tell us how you are getting the running time? Are you using
=NOW() and what cell is this in?

What are the 6 time ranges that you want the message to be active for?

Which cell do you want to use to display the message?

Pete

On Nov 18, 11:51*pm, KT wrote:
I have put the running time on a worksheet. *I want to reference that time
and for 6 time ranges during the day, I want to display a message to the user
via text in a cell. *How do I reference these time ranges and how do I
display this message only during these 6 time ranges?

Thanks!

Multiple Time Range Conditional
 

I accidentally double posted this. Solution I was looking for is in other
post. Thanks for your reply.

"Pete_UK" wrote:

Can you tell us how you are getting the running time? Are you using
=NOW() and what cell is this in?

What are the 6 time ranges that you want the message to be active for?

Which cell do you want to use to display the message?

Pete

On Nov 18, 11:51 pm, KT wrote:
I have put the running time on a worksheet. I want to reference that time
and for 6 time ranges during the day, I want to display a message to the user
via text in a cell. How do I reference these time ranges and how do I
display this message only during these 6 time ranges?

Thanks!

.