Hi All,
I am trying to derive a formula to calculate volume inflow. For example, our shift timing is 1 PM to 1 AM. So, any volume which is received between 1 AM to 1 PM to be considered as 1 PM only. To be more precise, if volume is received 03/24/2023 00:59:00 AM to be considered as same time; however, if volume is received at 03/24/2023 01:20:15 AM, then it should be considered as 03/24/2023 01:00:00 AM. Same way if it is received on 03/24/2023 11:56:00 AM, then it should be considered as 03/24/2023 01:00:00 PM.
I am trying with IF AND condition, but it throws FALSE. Kindly assist.
A B
Received_Date Closed_Date
1/28/2023 0:16 1/30/2023 15:05 12:16:00 AM FALSE
1/28/2023 1:18 1/30/2023 15:12 01:18:00 AM FALSE
formula used was =IF(AND(A2>="01:00:00 AM",A2<="01:00:00 PM"),"01:00:00 PM")
Bookmarks