| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I get excel to fill using a start and finish time
start finish 800 830 900 930 1000 830 1000 Look at start and finish time and show against the times above and colour using the fill option. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can I get excel to fill using a start and finish time
select your times and do Format=Conditional Formatting.
put in two conditions for the cell is equal to the start time, next condition equal to the finish time. -- Regards, Tom Ogilvy "djjom" wrote in message ... start finish 800 830 900 930 1000 830 1000 Look at start and finish time and show against the times above and colour using the fill option. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Start, Finish including break time | Excel Worksheet Functions | |||
| Calculate working hours from a start and finish time over several | Excel Worksheet Functions | |||
| Start & Finish Time | Excel Worksheet Functions | |||
| how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Linear Mode
