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.


[TABLE="width: 576"]
<colgroup><col width="64" style="width:48pt" span="9"> </colgroup><tbody>[TR]
[TD="width: 64, bgcolor: #C0C0C0"]Arrive: DATE[/TD]
[TD="width: 64, bgcolor: #C0C0C0"]NAME[/TD]
[TD="width: 64, bgcolor: #C0C0C0"]Gate[/TD]
[TD="width: 64, bgcolor: #C0C0C0"]Water meter[/TD]
[TD="width: 64, bgcolor: #C0C0C0"]Test [/TD]
[TD="width: 64, bgcolor: #C0C0C0"]Arrive: TIME[/TD]
[TD="width: 64, bgcolor: #C0C0C0"]Depart: DATE[/TD]
[TD="width: 64, bgcolor: #C0C0C0"]Depart: TIME[/TD]
[TD="width: 64, bgcolor: #C0C0C0"]TOTAL MINS[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]01.02.19[/TD]
[TD="bgcolor: transparent"]TEST 1[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]003738[/TD]
[TD="bgcolor: transparent"]Staff[/TD]
[TD="bgcolor: transparent"]0415[/TD]
[TD="bgcolor: transparent"]01.02.19[/TD]
[TD="bgcolor: transparent"]1540[/TD]
[TD="bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[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,"")