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]

Month	date	ID	OT HOURS
Jan	01/01/2018	raja
Jan	01/03/2018	raja	5
Feb	28/02/2018	raja	6
feb	28/2/2018	rani	1
MAR	01/03/2018	rani	6
mAR	04/03/2018	raja	18

<tbody>
</tbody>