Regular Working Hours & Overtime Hours Calculation Simplified | Time Sheet in MS Excel (Very Easy)
ฝัง
- เผยแพร่เมื่อ 11 ก.ย. 2024
- #TimeSheet #MSExcel #TimeSheetExcel #OvertimeCalculation
In this MS Excel Tutorial you will learn how to simply calculate regular working hours and overtime hours for employees in a timehseet.
The way of calculation for regulat hours and overtime hours is simple\y explained in full detail.
Awesome. I like the way you explain topic. Love it. ❤
excellent bro.
loved it. put practiced files in the description...
I can send you file by Email. Gove your Email id
Have you sent it, sir?
How to compute regular working hours and overtime using MOD function?
=MOD(TimeOut - TimeIn, 1)
@@MicrosoftOfficeTutorials How about getting the paid regular working hours and the overtime from the total hours? Also if its undertime?
Please share sample file in order to work on exact situation
Can you please make formula for me or teach me to make it. Our office working hours are 8:00 - 17:30 so calculating total working hours and over time hours before 8:00 Am & after 17:30 pm. And on (Saturday+Sundays+GH) days will be full overtime hours.?
Hi Dharmendr... What is GH in your comment
@@MicrosoftOfficeTutorials GH means Holiday
@@MicrosoftOfficeTutorials i made same kind of sheet with this formula but its not calculating properly and there is difference comes heavily. Like wise i can send you my whole scenario on Whatsaap and can explain what i want. Can you guide me?
@@DVG3591 sure, why not
@@MicrosoftOfficeTutorials still waiting for your Reply. Are you busy or can't able to solve my problem?
hi please solve my issue please
i need help from you please help
why dont you resolve my issue dear ?
Hi Dharmendr please check trick 4 and 5 in this video. I believe it will be helpful for you.
th-cam.com/video/djkQXFVGmVk/w-d-xo.html
@@MicrosoftOfficeTutorials Still its unsolved Dear. if you make the formula as per my conditions of over time hours. I will paid for it.
@@MicrosoftOfficeTutorials Please Solve the problem in my video.
@@MicrosoftOfficeTutorials why don't you make video on median, were normal duty timings excluded from actual timings. 🤔
@@MicrosoftOfficeTutorials please reply brother