Excel Magic Trick 1228

DESCRIPTION

Hours Worked Formula For Date & Time Values & Time Custom Number Format
Learn how to calculate hours worked for Pilot Layovers from Date and Time Values:
(00:10) Intro To Problem
(00:47) Serial Numbers for Dates and Times
(01:38) Hours Worked Formula For Date & Time Values
(02:25) Time Custom Number Format to display “76 Hours 50 Minute” (use Square brackets to display hours greater than 24 hours)

WORKBOOKS