Hi Guys
Happy New year friends please can someone help out with a formula that can extract the spent hours which is formatted with the formula in Cell L based on Multiple criteria and faster
i have tried using SUMIFS formula but showing zero without result
Happy New year friends please can someone help out with a formula that can extract the spent hours which is formatted with the formula in Cell L based on Multiple criteria and faster
i have tried using SUMIFS formula but showing zero without result
ILSP_Performance Tracking Data.xlsx | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | M | |||
10 | ||||||||||||||
11 | ||||||||||||||
12 | Year | Manifest | Voyage | Supply | D/P | Full | Lang Rigs | Location | Arrival & Start | Depature | Total Hrs | ADNOC-1010 | ||
13 | Month | Issued Month | MUS No. | Vessel | VSL | Half | Rigs & Complex | Site | Date & Time | Date & Time | Spent | Asseifiya Island | ||
14 | 01-Jan-21 | ADNOC-1010 | Asseifiya Island | 04/11/20 08:10 | 04/11/20 23:30 | 15 | 0 | |||||||
ILSP_Performance_Tracking |
Cell Formulas | ||
---|---|---|
Range | Formula | |
L14 | L14 | =TEXT(ABS(K14-J14),"[h]") |
M14 | M14 | =SUMIFS(Hours,Site,M13,Vessel,M12,Month,Month[@Month]) |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
G12:G13 | Cell Value | contains "M" | text | NO |
G12:G13 | Cell Value | contains "Naf" | text | NO |