| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Multiple Time Ranges | Excel Worksheet Functions | |||
| Time to time range formula??? | Excel Worksheet Functions | |||
| Converting time to a range of time | Excel Discussion (Misc queries) | |||
| Multiple Conditional summing for time sheet. | Excel Discussion (Misc queries) | |||
| conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
Hybrid Mode
