Deducting time ES2

emmad11800879

17-11-2016

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?

Accepted Solutions (0)

Answers (0)