Calculate Total minutes

[solotech]

Hi,
I need to know the total minutes between ARRIVE DATE / ARRIVE TIME and DEPART DATE / DEPART TIME.
Times are in 24hr format. Can someone show me how to update TOTAL MINS as data is entered please.
Thank you.

Arrive: DATE	NAME	Gate	Water meter	Test	Arrive: TIME	Depart: DATE	Depart: TIME	TOTAL MINS
01.02.19	TEST 1	1	003738	Staff	0415	01.02.19	1540

<colgroup><col width="64" style="width:48pt" span="9"> </colgroup><tbody>
</tbody>

 

[gaz_chops]

Not sure what formula you are using! Assuming the dates are now dates and the times are as before, try

=IFERROR(((G2+TIME(LEFT(H2,LEN(H2)-2),RIGHT(H2,2),0))-(A2+TIME(LEFT(F2,LEN(F2)-2),RIGHT(F2,2),0)))*1440,"")