To calculate hours worked in Excel, you can usually just subtract the start time from the end time--as long as the work shift doesn't span over midnight. If you need to calculate hours worked for the 11:00 PM to 7:00 AM shift, simple subtraction won't do.