Vba for monthly timesheet of employees

[abdulkadirbhati]

I need help to make vba for attached sample file to sum of columns as normal hrs(8) and overtime hrs and Friday to count as overtime and if any employee reported on Thursday Friday normal hrs 8 count automatic

[Miroslav R.]

Hi there,
a little explanation needed:
If someone has worked on Thursday, those 8 hours on Friday should be calculated as normal + XY overtime?

(Because in Your example in row 6: sum of all hours is 310hrs, but in the summary You have 248+102 = 350hrs.)

[abdulkadirbhati]

I want only normal hrs seprate and ot hrs separate 248+102 =350(total Hrs is not required),I need only normal and ot hrs seprate,please note if month change then Friday column also change then vba work or not

Thanks