Calculate overtime hours in Excel
Опубликовано: 13 Октябрь 2024
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
180
0
00:00 Calculate hours worked with Excel (normal, overtime, short time)
00:15 Show the lesser of hours worked or 8 hours (full normal hours)
00:46 Show overtime hours worked when total hours is more than 8 hours
01:43 Show hours leave taken if they worked less than a full day
Use Excel to create a timesheet calculator where, using IF functions, we can check the hours worked in a day and differentiate them between normal hours (the first 8 hours worked), overtime hours (any hours after 8 hours on a day), short hours set against leave (any hours less than the minimum of 8 hours for a normal working day).
