DON'T CALCULATE OVERTIME HOURS LIKE THIS IN EXCEL

@j.techmaster0

27.3K followers · usually 4.7K views a post

Views

41.0K

Likes

1.1K

Comments

8

Shares

156

SoundTikTok sound · original sound - j.techmaster0

Promoted product

Microsoft Excel

Create and edit spreadsheets online with Microsoft Excel for the web. Easy formatting, analysis, and real-time collaboration from any device.

26 videos13 creators

Why it worked

The video provides a practical and quick solution to a common problem faced by many Excel users, making it highly shareable and valuable content. The clear demonstration and concise explanation of the formula contribute to its effectiveness.

Summary

The video demonstrates a more efficient method for calculating overtime hours in Microsoft Excel using the MOD and IF functions. It shows how to input the formula and drag it down to apply it to all entries, providing the correct overtime hours.

Structure

1Introduction to the problem: calculating overtime in Excel manually.
2Demonstration of the manual method and its inefficiency.
3Introduction of the MOD function for calculating total hours.
4

Original caption

Calculate Overtime in Excel | Excel Amazing Trick #excel @Digital Work @Digital Work #exceltips #microsoftexcel #exceltricks

More from @j.techmaster0

Product placement

Microsoft Excel: it is used to calculate overtime hours. The video demonstrates how to use formulas within Excel to achieve this. Microsoft Excel is acted upon. Removing it would change what happens in the video.

Call to action

follow me on instagram and also you can subscribe my channel and also you can download my application

On-screen text

DON'T CALCULATE OVERTIME HOURS LIKE THIS IN EXCEL Working Hours : 8 Out Time Total Hours Overtime Hours In Time 7-2026 9:00 AM 10:30 PM 13.5 5.5 7-2026 9:15 AM 5:00 PM 7.75 0 7-2026 8:45 AM 7:15 PM 10.5 2.5 7-2026 10:00 AM 6:00 PM 8 0 7-2026 9:30 AM 10:00 PM 12.5 4.5 7-2026 8:30 AM 4:30 PM 8 0 7-2026 9:00 AM 7:00 PM 10 2 7-2026 9:45 AM 5:30 PM 7.75 0 7-2026 8:00 AM 6:45 PM 10.75 2.75 7-2026 9:15 AM 7:15 PM 9 1 7-2026 10:15 AM 5:00 PM 8 0 7-2026 8:30 AM 7:30 PM 11 3 7-2026 9:00 AM 6:20 PM 9 1 7-2026 10:00 AM 5:30 PM 7.5 0 7-2026 8:15 AM 8:15 PM 11.5 3.5 7-2026 9:30 AM 5:30 PM 8 0 7-2026 9:10 AM 7:40 PM 10.5 2.5 7-2026 10:30 AM 6:00 PM 7.5 0 7-2026 8:00 AM 5:00 PM 9 1 7-2026 9:00 AM 8:30 PM 11.5 3.5 this in excel instead of this you can use one amazing trick that is simply what you can do your total hours so that we can use here mod function open the bracket we can select out time minus end time then minus end time then we can use comma and one for divisor close the bracket and we can multiply it with 24 and you can convert this into general format and now you can drag this function down and for over time you can use if this total hours is greater than 8 then total hours minus 8 else we need 0 here simply close the bracket and enter we are getting this overtime hours here so this is how you can calculate overtime in excel if you like this video don't forget to share this video and if you want to learn excel from basic to advanced level with AI tools you can simply follow me on instagram and also you can subscribe my channel and also you can download my application thank you so much

Transcript

DON'T CALCULATE OVERTIME HOURS LIKE THIS IN EXCEL DON'T CALCULATE OVERTIME HOURS LIKE THIS IN EXCEL this in excel Working Hours : 8 Out Time Total Hours Overtime Hours In Time 7-2026 9:00 AM 10:30 PM 13.5 5.5 7-2026 9:15 AM 5:00 PM 7.75 0 7-2026 8:45 AM 7:15 PM 10.5 2.5 7-2026 10:00 AM 6:00 PM 8 0 7-2026 9:30 AM 10:00 PM 12.5 4.5 7-2026 8:30 AM 4:30 PM 8 0 7-2026 9:00 AM 7:00 PM 10 2 7-2026 9:45 AM 5:30 PM 7.75 0 7-2026 8:00 AM 6:45 PM 10.75 2.75 7-2026 9:15 AM 7:15 PM 9 1 7-2026 10:15 AM 5:00 PM 8 0 7-2026 8:30 AM 7:30 PM 11 3 7-2026 9:00 AM 6:20 PM 9 1 7-2026 10:00 AM 5:30 PM 7.5 0 7-2026 8:15 AM 8:15 PM 11.5 3.5 7-2026 9:30 AM 5:30 PM 8 0 7-2026 9:10 AM 7:40 PM 10.5 2.5 7-2026 10:30 AM 6:00 PM 7.5 0 7-2026 8:00 AM 5:00 PM 9 1 7-2026 9:00 AM 8:30 PM 11.5 3.5 this in excel instead of this you can use one amazing trick that is simply what you can do your total hours so that we can use here mod function open the bracket we can select out time minus end time then minus end time then we can use comma and one for divisor close the bracket and we can multiply it with 24 and you can convert this into general format and now you can drag this function down and for over time you can use if this total hours is greater than 8 then total hours minus 8 else we need 0 here simply close the bracket and enter we are getting this overtime hours here so this is how you can calculate overtime in excel if you like this video don't forget to share this video and if you want to learn excel from basic to advanced level with AI tools you can simply follow me on instagram and also you can subscribe my channel and also you can download my application thank you so much