Excel & Business Math 32: Rounding Time Calculations to Nearest 5 or 15 minutes using MROUND

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

[LeilaGharani]

MROUND is great! Thanks for this great video!

[rubencorderotorres]

It's so usefull, excactly than I needed, thanks a lot Mike

[tranquilitypools]

This man Always comes through 100 % Best

[nsanch]

Thanks Mike. Finally figuring out time.

[johnborg]

Thanks Mike Amazing. Never seem to get tired. I have been following for years.

[myunghayes]

All in One was a bit complicated but I managed it. Keep practising!!! Thanks again BUSINESS MATH lesson is perfect for me.

[chrism]

Cool, I have never used this before. Great video Mike!

[samadritachowdhury]

Sir kindly do a series of videos on Basic SQL tutorial like Your Excel Basics Videos :)

[ismailismaili]

thank you so much i got the MRound but please if i want to round to hours and no minutes or seconds am I going to round to the hours like this 01:00:00 ?thank you for the video

[YAKMAN]

Good day sir!
I have a column range In B_Range, ie. (B4:B1004) I have numbers incrementing from 1 to 1000. What I want here is my constant value from A cell should get multiplied with each number of B column and incrementing values in C column.

Please reply ASAP

[omkarpolekar]

how to round off minutes instead of a particular time