Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

LinkBack Thread Tools Display Modes
Old 01-17-2016, 02:50 AM
ellebb85 ellebb85 is offline Windows Vista Office 2016
Join Date: Jan 2016
Posts: 2
ellebb85 is on a distinguished road
Default Marking specific cells depending on start and end time entered


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!
Reply With Quote

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

All times are GMT -7. The time now is 10:03 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft