Oct 13 2020 09:16 AM
hi
I want to get the total of subtracting each cell from 18 Sep till 24 Sep with the daily WH
ex. =(12.16 -11)+(12.17-11)+(16-11) and so on
Daily WH | 18-Sep-20 | 19-Sep-20 | 20-Sep-20 | 21-Sep-20 | 22-Sep-20 | 23-Sep-20 | 24-Sep-20 | |
11 | 12.16 | 12.17 | 16 | 15.45 | 16.49 | 17.01 | 16.55 |
Oct 13 2020 09:24 AM
Like this?
Oct 13 2020 09:24 AM
Oct 13 2020 12:08 PM
can I add an if condition to calculate only if the value is above Daily WH
and another one for if the value is less than Daily WH
Oct 14 2020 09:53 AM
thank you for your answer it helped me a lot
same formula I want to calculate on if the number is greater than 11, and another formula only if the number is less than 9
Daily WH | 18-Sep-20 | 19-Sep-20 | 20-Sep-20 | 21-Sep-20 | 22-Sep-20 | 23-Sep-20 | 24-Sep-20 | |
11 | 12.16 | 12.17 | 10.1 | 15.45 | 16.49 | 9 | 16.55 |
like the extra Hrs are (12.16-11)+(12.17-11)+(15.45-11) and so on
and for the less Hrs ONLY (11-10.1)+(11-9) and so on
Oct 14 2020 10:07 AM
Oct 14 2020 10:31 AM
Oct 14 2020 12:46 PM
Oct 14 2020 02:38 PM