Thasthahir
New Member
- Joined
- Mar 6, 2018
- Messages
- 9
Hi ,
[FONT="]Have a clarification in excel formula. I have creating a template file now. It is related to hours Calculation.[/FONT]
[FONT="]
[/FONT]
[FONT="]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="]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]
<tbody>
</tbody>
[FONT="]Have a clarification in excel formula. I have creating a template file now. It is related to hours Calculation.[/FONT]
[FONT="]
[/FONT]
[FONT="]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="]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>