Excel Magic Trick 1206: Day & Night Shift Time Calculations: Add Total Hours Single Cell Formula

About this tutorial:

Video duration: 10:35
Download File:
See how to create a single cell formula that calculates the total hours worked for the week given a column of start times and a column of end times:
1. (00:10) Problem Setup
2. (01:00) Time Values in Excel are decimals between 0 and 1 that represent the proportion of a 24 hour day.
3. (02:13) Basic Time Calculation: End Time – Start Time
4. (03:11) IF formula for Day & Night Shift Time Calculations
5. (03:55) MOD function for Day & Night Shift Time Calculations
6. (05:00) Explanation of MOD algorithm: n-d*INT(d/n)

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *