Hi,
first post in the forum, im needing a formula to check that a date and time stamp is between a certain date and time range
B1 = priority (value from 1 to 4) using value 1 in this example
C1 = Start date and time
G1 = End date and time
H1 = duration between C1 and G1
L1 requires a formula to check if the start date and time C1 is between 8:00 am and 6:00 pm on that day if yes check the duration is no more than 15 mins, or show blank cell
M1 requires a formula to check if the start date and time C1 is before 8:00 am and greater than 6:00 pm on that day if yes check the duration is no more than 30 mins, or show blank cell
im have variable data in the sheet of records so the formula will be dragged down to fit the data.
I have tried to extract the date and portion and concatenate the time stamp to get a variable to check the start time against but with no luck.
hope someone can give me a bit of help thanks.
Normally if this was value I can write an If statement but using the date portion of the start point and adding a time stamp is stopping me completing the task.
Bookmarks