How to: Use Excel to calculate the shift hours worked
With Microsoft Excel, you can create a worksheet that figures the hours worked for any shift. Follow these step-by-step instructions. 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. But if the work shift spans noon or midnight, simple