Hi!
I need to calculate "Full Day" or "Half Day" in Sheet 2 at D3.
Sheet 1 having data from A3:D504, where
A3:A504 having "Date" e.g. 03-03-2024
C3:C504 having "Category" like Lunch, Hi Tea, Dinner, Setup, PMT, AMT etc
D3:D504 having "Space" like ATR, ATR1, ATR2, ATR3, DRM etc.
Full Day"...