Rubin Shrestha
Zend certified PHP/Magento developer
Rubin Shrestha
Blog

i need to sum morning shift for 8 AM till 13:00 PM

by |Published

I want to sum for month of January 2023 from time 8 AM till 1 PM (13: 00) Only​
I used the following formula =SUMPRODUCT((Sheet1!$A$4:$A$151>=DATE(2023,1,1)+TIME(8,0,0))(Sheet1!$A$4:$A$151<=DATE(2023,1,1)+TIME(13,0,0))(Sheet1!$B$4:$B$151))​
and =SUMIFS(Sheet1!$B$4:$B$151,Sheet1!$A$4:$A$151,”>=”&DATE(2023,1,1)+TIME(8,0,0),date,”<=”&DATE(2023,1,1)+TIME(13,0,0))​
both of them gave me the wrong result​
please need your help
Best Regards​

You may also like