# If and condition to calculate time

1. ## If and condition to calculate time

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
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")

2. ## Re: If and condition to calculate time

Not sure 100% I can understand, but:
use:
``Please Login or Register  to view this content.``
or
``Please Login or Register  to view this content.``
I wish you could manual input some expected results

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1