Calculate the difference between OUT time and IN time and ignore empty Out time instead use current time

[sivarythm]

I am looking for a macro code or formula to return the total elapsed time from multiple in and out using current time.(See attached image)

Here I am calculating the time difference between out time- in time to find staff field hours and also I'm alerting the field staff if he spent more than 6 hrs in the field using rolling time(Current time -in time). But My formula returns error, if there is no value in IN time. could you please suggest any solution?. thanks

 

[jasonb75]

You could try

=MAX(0,IF(...))+MAX(0,IF(...))

But that will only work if the blank cells are empty, if they are formulas that show "" then it will need more changes.