Return to site

Ms excel formula to subtract 4 hours

broken image

LEARN MORE: Office 365 Consumer pricing and features

broken image
broken image

However, you can easily create an Excel worksheet that correctly figures the hours worked for any shift. But if the work shift spans noon or midnight, simple subtraction won’t cut it.

broken image

To calculate in Excel how many hours someone has worked, you can often subtract the start time from the end time to get the difference.

broken image