Excel Magic Trick 1057: Calculate Hours Worked From Text Time Values, Including Night Shift

0 Просмотры
Издатель
Download Excel Start File:

Download Excel File:
See:
1. See how to use the TEXT and MOD functions, along with Custom Number Formatting to create a formula that calculates hours worked from time values stores as text with leading zeros.
Related video:
Excel Magic Trick 286: MOD function & Time Calculations (Time For Night Shift, or Negative Time)
Back Slash For Custom Number Formatting in Excel
Категория
Развлекательное
Комментариев нет.