Download Start Excel File: http://ift.tt/2BIoisJ
Download pdf Notes: http://ift.tt/2Cc8QGG
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to use the MROUND Function to round a time calculation to the nearest 5 minutes or nearest 15 minutes.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (00:14) How To use MROUND for Payroll or Product Pricing
3. (06:13) MROUND on a Payroll Time Sheet
4. Day Shift or Night Shift Payroll calculations. See MROUND, MOD and ROUND Functions to make time calculations rounded to the neatest 5 minutes and then calculate Gross Pay for each employee
5. () Summary
Next Video: 33 Excel & Business Math