I am trying to calculate some 24hr times. This is what I have.
I have 4 x times. Start (a), finish (b),2nd start (c) and 2nd finish (d)
If the time difference between b and c is 20mins or less I want e = a + d
If the time difference is greater than 20 mins e = (a + b) +(c + d)
The answer I am looking for is the difference in times. ie 1530 +1545 = 0.15
Please help
I have 4 x times. Start (a), finish (b),2nd start (c) and 2nd finish (d)
If the time difference between b and c is 20mins or less I want e = a + d
If the time difference is greater than 20 mins e = (a + b) +(c + d)
The answer I am looking for is the difference in times. ie 1530 +1545 = 0.15
Please help