Finally! Thank you for this. Exactly what I needed for my payroll calculations.
@excelisfun
2 жыл бұрын
You are welcome, fairygod mother!!!!
@sachinrv1
6 жыл бұрын
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.
@excelisfun
6 жыл бұрын
You are welcome for the share!!!! Thanks for your support with your comment, Thumbs Up and Sub : )
@shubhambhalekar3926
2 жыл бұрын
Thanks you so much love from India
@excelisfun
2 жыл бұрын
You are welcome from Seattle, WA, USA. Thanks for the love : )
@arjuhussain6444
5 жыл бұрын
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!
@excelisfun
5 жыл бұрын
You are welcome, Arju!!!! Thanks for your support with your comment, thumbs up and your Sub : )
@PostSasso
2 жыл бұрын
@@excelisfun You sound like a smart Dr. Phil.
@excelisfun
2 жыл бұрын
@@PostSasso Too funny... lol : )
@Siggy79
6 жыл бұрын
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
@diazmiramontes
6 жыл бұрын
You read my mind. I was trying to figure this out today. Thank you!!!
@excelisfun
6 жыл бұрын
You are welcome! Thanks for your continued support with comments and Thumbs Up : )
@ismailismaili0071
6 жыл бұрын
OMG Supper genus i really love you Mr. Mike i really love the video especially the true and false that really blow my mind
@excelisfun
6 жыл бұрын
Glad you like it, Ismail! Thanks for your continued support : )
@DougHExcel
6 жыл бұрын
what a timely video...thanks Mike!
@excelisfun
6 жыл бұрын
Thanks, Excel & Pun Teammate : )
@OakleyTurvey
6 жыл бұрын
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.)
@excelisfun
6 жыл бұрын
Glad you like it, Teammate!!!
@lusmolina115
Жыл бұрын
Hi, Thank you so much for the video. helped me a lot. How I can do this formula with 2 breaks?
@drsteele4749
6 жыл бұрын
Excellent summary of an important principle...super, Mike!
@excelisfun
6 жыл бұрын
Thanks, DRSteele!!!
@Meolimo
6 жыл бұрын
Tks Mike, you answer for the most of my question. Now I will try to apply this rules with Power qery ;-)
@excelisfun
6 жыл бұрын
Glad the vid helps!
@johnborg6005
6 жыл бұрын
Amazing!!! I use the MOD Function which I have seen in your earlier videos (going some years back :) )
@rangasudhakar
6 жыл бұрын
Calculating the Night Shift hours using MOD function was toooooooooooooo Good.
@alexxgalindo8557
2 жыл бұрын
Thanks a lot sir, you're amazing
@excelisfun
2 жыл бұрын
Glad this helps!!!
@SyedMuzammilMahasanShahi
6 жыл бұрын
EXCELlent video by Amazing Mike :P ... Thanks Man!!
@excelisfun
6 жыл бұрын
You are welcome, Man! Thanks for your Amazing support : )
@krn14242
6 жыл бұрын
Thanks Mike.
@excelisfun
6 жыл бұрын
You are welcome, WRH!!!!
@sweetmask1690
4 ай бұрын
Hello How can I get the night differential of 1:00am -6:00am ?
@pmsocho
6 жыл бұрын
That was smart: =C11-B11+(C11
@Luciano_mp
6 жыл бұрын
Excelente, obrigado.
@excelisfun
6 жыл бұрын
Thanks for watching : )
@villiageheart
6 жыл бұрын
Do you have a rotating shift schedule for 24/7 video?
@سليمملي
6 жыл бұрын
Tks Mike (My name is Salim) and i have a question Can we use this formula: (Max(c4,d4)-Min(c4,d4))*24
@TheAdmirspahic
4 жыл бұрын
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.
@theladyrblog
3 жыл бұрын
Omg that's exactly what I am trying to figure out , did you find a way to do it ?
@charmedforever4245
2 жыл бұрын
Me too
@samanthaguzman6625
5 жыл бұрын
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.
@thx2813
6 жыл бұрын
Excelente Mike ! You might be so kind of putting Subtitles in Spanish too, please!! Best regards "
@excelisfun
6 жыл бұрын
I am sorry but I already work 10 + hours every day for the last 10 years, and I do not have the expertise or resources to do that ... : (
@thx2813
6 жыл бұрын
ExcelIsFun Ok I'm going to have to perfect my English, bro ! thanks so much !
@beraswarup
4 жыл бұрын
How to calculate tat excluding midnight
@mohamedchakroun4973
6 жыл бұрын
Thumbs up :-)
@anonymousperson4363
2 жыл бұрын
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.
@excelisfun
2 жыл бұрын
None of the formulas have flaws if you are using time values in Excel. So I am not sure what you are referring to.
Пікірлер: 54