Hours calculation

[Lukma]

Hi friend

Need a little help with a formula i need to subtract the 08/05/2024 05:48 - 01/05/2024 00:06 then Subtract Q & R & S result formula and get the total Hours in Column V
Appreciate any formula to get this done

Thanks

Column I1

Q​

R​

S​

Column U

V

01/05/24 00:06

01/05/24 00:06

01/05/24 01:12

01/05/24 02:00

01/05/24 11:42

01/05/24 12:00

11:54

21:00

21:48

MUTAWA-306

08/05/24 05:48

Tonnage ata0Report may 0814hrs.xlsx
	I	J	K	L	M	N	O	P	Q	R	S	T	U
5478	01/05/24 00:06	01/05/24 00:06	01/05/24 01:12	01/05/24 02:00	01/05/24 11:42		01/05/24 12:00	11:54		21:00	21:48	MUTAWA-306	08/05/24 05:48
Vessel_Trip_Activities

Cell Formulas
Range	Formula
P5478	P5478	=IF(N5478="", IF(O5478<>"",O5478- I5478, ""), IF(N5478<>"", N5478 - I5478, ""))
Q5478	Q5478	=IF(N5478="", "", IF(O5478="", "",O5478- N5478))
T5478	T5478	=IFNA(VLOOKUP($E5478,$E5479:$O$60000,1,0),"")
U5478	U5478	=IFNA(VLOOKUP($E5478,$E5479:$O$60010,5,0),"")

 

[myall_blues]

I believe it should be:

=(U5478-I5478-SUM(Q5478:S5478))*24

 

[Lukma]

I believe it should be:

=(U5478-I5478-SUM(Q5478:S5478))*24

Many Thanks Myal_Blues

I appreciate

Thanks