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]
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]