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?
Bookmarks