LinkedIn
Twitter
hello everyone;
i am making a program that calculates the annual leave of employees. But i ran into a problem which is;
KAZANILAN_IZIN = annual leave earned
KULLANILAN_IZIN = annual leave used
KALAN_IZIN = remaining annual leave
formula is used in the same table
the formula = annual leave earned - sum of the previous annual leaves used - leave used in this form(number of between two dates)
dates = start date , end date
= 120 - sum of the previous annual leaves used - 1 = 119 >> this is true result but;
= 120 - sum of the previous annual leaves used - 1 = 118 >> this is false result
when i looking tablet mode result is true;
when i looking desktop mode result is false
same formula but different result
how can i fix it ?
I suggest to rewrite your formula to use hours instead of days, and in the end divide the hours by 24
Date1 -Date2 gives a Duration result
https://support.google.com/appsheet/answer/10107326?hl=en
edit : one of my apps formula , but it takes into account multiple things, like weekend days, national holidays , non approved leaves..
If([aprobat]="nu";0;HOUR([DataConcFinal]-[DataConcStart])/24 +1 -(2*(weeknum([DataConcFinal])-weeknum([DataConcStart])+1) - ( ifs(weekday([DataConcStart])<>1;1)+ ifs(weekday([DataConcFinal])<>7;1) ))-count(select(libera nat[ziua cal];and([ziua cal]>=[DataConcStart];[ziua cal]<=[DataConcFinal];weekday([ziua cal])<>1;weekday([ziua cal])<>7);true)))
