Thasthahir
03-05-2018, 06:54 PM
Hi,
Have a clarification in excel. I have creating a 2018th year template file now. It is related to hours Calculation.
Concept is : Leader will update users extra working hours in a sheet. As per company policy all users should be extend 8 hours per month.
If any one not extend 8 hours per month balance hours should be automatically added (Carry forward ) to next month. if user did more than 8 hours extra hours no need to carry forword to next month. can you please help me? Thank you...
For eg: if user A did 4 hours OT in jan month. as per policy he should spend 8 hours. balance 4 hours shouild be add in feb month
now feb month should reads 12 hours
Regards,
Mohideen Thasthahir
Have a clarification in excel. I have creating a 2018th year template file now. It is related to hours Calculation.
Concept is : Leader will update users extra working hours in a sheet. As per company policy all users should be extend 8 hours per month.
If any one not extend 8 hours per month balance hours should be automatically added (Carry forward ) to next month. if user did more than 8 hours extra hours no need to carry forword to next month. can you please help me? Thank you...
For eg: if user A did 4 hours OT in jan month. as per policy he should spend 8 hours. balance 4 hours shouild be add in feb month
now feb month should reads 12 hours
Regards,
Mohideen Thasthahir