Excel value carry forward to next month formula

[Thasthahir]

Hi ,


[FONT=&quot]Have a clarification in excel formula. I have creating a template file now. It is related to hours Calculation.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Concept is : Leader will update users extra working hous in a sheet. As per company policy all users should be extend 8 hours per month. [/FONT]
[FONT=&quot]If any one not extend 8 hours per month it should be automatically added (Carry forward ) to next month. can you please help me? Thank you...

EG:[/FONT]

[TABLE="class: cms_table_grid, width: 500, align: center"]
<tbody>[TR]
[TD]Month[/TD]
[TD]date[/TD]
[TD]ID[/TD]
[TD]OT HOURS[/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD]01/01/2018[/TD]
[TD]raja[/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD]01/03/2018[/TD]
[TD]raja[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Feb[/TD]
[TD]28/02/2018[/TD]
[TD]raja[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]feb[/TD]
[TD]28/2/2018[/TD]
[TD]rani[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]MAR[/TD]
[TD]01/03/2018[/TD]
[TD]rani[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]mAR[/TD]
[TD]04/03/2018[/TD]
[TD]raja[/TD]
[TD]18[/TD]
[/TR]
</tbody>[/TABLE]