#1
|
|||
|
|||
Marking specific cells depending on start and end time entered
Hi,
I have attempted to think through this myself but am drawing a blank so any help would be appriciated. I have a spread sheet with time intervals going across 1 row, 08:00, 09:00 etc. If possible I need a formula in each cell of the row underneath, that if I specify the start and end time i.e 08:00-15:00 it will review the interval period above and show as a 1 if it sits within the time scale. Any help would be greatly received! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting- Only format cells once data is entered | chart3 | Excel Programming | 1 | 12-15-2015 11:26 AM |
Control Time Calculaiton depending on whether line is running or not. | rdperry11 | Excel | 4 | 02-24-2015 09:35 PM |
Help - Run-time error 91 - VBA for inserting and formatting text depending on style | mtrborges | Word VBA | 2 | 02-08-2015 11:35 PM |
How to create a table with a number of line depending a number entered by user | Cellendhyll | Word Tables | 3 | 07-10-2014 05:49 AM |
Automaticaly marking specific domains recipients in TO filed | kapucino | Outlook | 3 | 10-23-2011 09:59 PM |