Expand my Community achievements bar.

Deducting time ES2


Level 2

I need to deduct time from two cells - ie cell one (called DateTimeField1) is 16:30 and cell two (DateTimeField2) is 18:00 the answer in cell 3 (NumericField1) should be 1:30

Time could go over night - so I need a script (formcalc) that will allow for this (ie start time 21:00 - finish time 07:00 = 10:00

can anyone help please?

0 Replies