I am creating a timesheet for our 24 hour operation and I have run into
difficulty when the work shift crosses over midnight. The formula works
perfect when the shift starts at 7:00 am but when the shifts start at 7:00 pm
and crosses over midnight it shows -12 hours worked for the shift.

Shifts are always changing so the same person can be on nights and days
during the same pay period. Do I need to include the date in this
calculation?

Thanks for your help.