Forum Discussion

Copper Contributor

Apr 08, 2023

missing time calculations

hi I have a "missing time" issue. I am inputting start time, finish time, and then missing time. the work sessions are 4hrs and I need to have the missed times from the 4hrs. I have the calculati...

Formulas and Functions

HansVogelaar

MVP

Apr 08, 2023

chris_may

Perhaps in C4:

=IF(OR(A4:B4=""),0,MAX($B$1-(B4-A4),0))

Fill down.