Excel Magic Trick 1228: Hours Worked Formula For Date & Time Values & Time Custom Number Format

preview_player
Показать описание

Learn how to calculate hours worked for Pilot Layovers from Date and Time Values:
1. (00:10) Intro To Problem
2. (00:47) Serial Numbers for Dates and Times
3. (01:38)Hours Worked Formula For Date & Time Values
4. (02:25) Time Custom Number Format to display “76 Hours 50 Minute” (use Square brackets to display hours greater than 24 hours)
Рекомендации по теме
Комментарии
Автор

I 'm learning on your chanel more than from any excell-teaching-book that I've ever bought. Thanks!

FRANKWHITE
Автор

Pilots in the file, plane sound in the background great sync! :)

pmsocho
Автор

I have question. How can i hide all column and row accept my work area.

Dave-kdfo