Hi,

i'm new to timesheets, but had a question regarding modifying the formula listed below:

=Q2-P2+(Q2<A2)

it works as intended for a time interval that crosses over midnight, but with any normal interval, an additional 24 hours is added to my duration.

i'm attempting to use a single formula for all durations, so is there anyway to integrate an IF/THEN statement to subtract 24:00 hours if the calculated value is greater than 24:00?