Excel & Business Math 31: Night Shift Hours Worked Formula for Payroll Time Sheet (3 Examples) 

Thank you!!!! just what I needed.

Simply great. You are correct; MOD is not so popular and people always comes up with IF as a solution for most of their challenges in Excel. Thanks for sharing.

I'm running a bit behind on my vids but wanted to react to this one. First of I like the use of true or false to add 1 to the date, learned something new. Second: Being from Belgium we don't use the am/pm style what makes using date/time in formulas a bit easier in my eyes. When I encountered the problem with nightshift I simply used the date/time as total. For example 28-08-18 17:25. If you use the combination if date and time you never end up with a negative time because 1am tomorrow would be 29-08-18 01:00. Keep up the good work while I try to catch up on my backtrack on youtube vids

Finally! Thank you for this. Exactly what I needed for my payroll calculations.

I don't kw how to thank you enough man! I was gonna through my entire spreadsheet away, but you managed to save it. Thank You!

You read my mind. I was trying to figure this out today. Thank you!!!

what a timely video...thanks Mike!

OMG Supper genus i really love you Mr. Mike i really love the video especially the true and false that really blow my mind

Thanks you so much love from India

Tks Mike, you answer for the most of my question. Now I will try to apply this rules with Power qery ;-)

Amazing!!! I use the MOD Function which I have seen in your earlier videos (going some years back :) )

Hi, Thank you so much for the video. helped me a lot. How I can do this formula with 2 breaks?

Excellent summary of an important principle...super, Mike!

Respected, Do you have a formula to calculate if daily work counts from 6am to 10pm and night work counts from 10pm to 6am. For example, if I work a shift from 16:00 to 24:00, the formula would calculate that I worked 6 hours a day shift and 2 hours a night shift.

Calculating the Night Shift hours using MOD function was toooooooooooooo Good.

Nice one Mike. Another gem for the archives. (Everyone seems to be working on payroll at the moment...must be coming up to pay-day.)

Thanks a lot sir, you're amazing

That was smart: =C11-B11+(C11

Thanks Mike.

Hello How can I get the night differential of 1:00am -6:00am ?

Excelente, obrigado.

EXCELlent video by Amazing Mike :P ... Thanks Man!!

Do you have a rotating shift schedule for 24/7 video?

How can you calculate with day shift hours, night differential, & night differential over-time? I'm trying to figure how I could format in separating night diff when it starts.

Tks Mike (My name is Salim) and i have a question Can we use this formula: (Max(c4,d4)-Min(c4,d4))*24

How to calculate tat excluding midnight

Excelente Mike ! You might be so kind of putting Subtitles in Spanish too, please!! Best regards "

Thumbs up :-)

Both #1 and #2 have flaws. I don't know about #3. For example, if you start at 1 pm and finish at 2 pm the next day, it will only show one hour.