Hello again! I have a question here. Hope you can help me out with a formula.
I attached the snapshot.
Based on the 4th column, I want to put in the
Anything beyond 18:00 – 23:30 , date convert should be NEXT Day (4/1/2024), but if time is from 1:00 – 12:00, date convert will remain same day. (4/1/2024)
"Date Convert" “Interval 30 Mins”
Instead 3/31/2024 should reflect as 4/1/2024 – (23:00 - 00:00)
4/1/2024 – (3:00 - 3:30)
can you help me create a formula on this? thank you
Bookmarks