Hi all,
Im in need of some help with a multiple conditions formula. I have a vehicle booking workbook with a daily booking view. I am trying to break it down into part days but cannot get the conditions to meet.
The formula i am using is:
F = Start Date
G = End Date
H = Car Make
I = Car Registration
D = Start Time
E = End Time
Thank you very much in advance for your help.
Regards,
Pete
I can get the formula to meet the conditions for the beginning time of each day but not to recognize the end time on a different day.
Im in need of some help with a multiple conditions formula. I have a vehicle booking workbook with a daily booking view. I am trying to break it down into part days but cannot get the conditions to meet.
The formula i am using is:
Code:
=IF(AND($B17<>"",$C17<>""),1-SUMPRODUCT(('Car Reservation'!$F$2:$F$1000<=E$15)*('Car Reservation'!$G$2:$G$1000>=E$15)*('Car Reservation'!$H$2:$H$1000=$B17)*('Car Reservation'!$I$2:$I$1000=$C17)*('Car Reservation'!$D$2:$D$1000<=E$16)*('Car Reservation'!$E$2:$E$1000>=E$16)),"")
F = Start Date
G = End Date
H = Car Make
I = Car Registration
D = Start Time
E = End Time
Thank you very much in advance for your help.
Regards,
Pete
I can get the formula to meet the conditions for the beginning time of each day but not to recognize the end time on a different day.