Excel - calculate difference in time across midnight by Chris Menard

Dang Finally found the answer thank you awesome

Amazing. Thanks so much for this video. You saved me a lot of trouble.

Thanks alot! The formula is much more easier than the one that I used previously. It is very helpful!

amazing! it works but can you please explain why the +1

Thank you so much for saving my time. So simple and effective solution

I wish I found this sooner. Thanks a lot for making it the simplest!

Very helpful, thank you!

Thank you

Really helpful friend. Thanks a lot for sharing. Also can u share the reasoning behind it pls. I can't figure it out.

Great creative soluation

Help! I tried this and I'm getting the message "The formula in this cell differs from the formulas in this area of the spreadsheet" and it is showing as a time rather than a number. The span is 12:13 pm to 12:24 am and the cell with the formula is reading 12:41 AM

I keep getting the “value” error 🤦🏼‍♂️

Thank you! What if I also have break times that should not be counted in the time?

Hey Chris! Great video and it worked great but how would I be able to get a total? When I do =SUM(cell:cell) it gives me a huge count of hours even if there are no hours inputed

Thank u bro..

Thank you! Worked perfectly!

Cheers Chris

Thanks for sharing this, Chris! Saved my time.

thanks for sharing

thanks, works that way i want it.

Thank you, this worked but can you tell me how you found out/used +1 in the false statement?

Thank you so much, this was so helpful!

What if you had multiple people, is there a way to combine it into one, Like you have the raw data then on a separate one you have like their total for a week.

Thanks! Worked perfectly and well beyond my excel skills

Thank you sir!

Thank you!!

Thank you!!!!!!!

I have copy and past your VB formula and it works great. The only problem is when I go to clear out multiple cells at a time I get a debugging error.The error that is highlighted is xWord = Format(Target.Value, "0000"). Any suggestion? Thanks

thank you for this video. I spent way too much time trying to figure out this issue myself!

Lol. I'm not even doing this for a job, just to prove a point to a person i know. Thanks so much man

How on God's green earth is this video not getting more likes, shares, and comments? I have been looking to solve this issue for a good 4hrs now and this formula actually translated perfectly into google sheets!

You are awesome Chris!