Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie: Mayyy
 | Femeie 19 ani Brasov cauta Barbat 23 - 60 ani |
|
TRaP
Moderator
Inregistrat: acum 7 ani
Postari: 822
|
|
=IF(Z14>0;NETWORKDAYS.INTL($U$2;$U$3;1;LIBERE)*8-Z14;0)
Z14 = the number of hours resulted physically from reported production for example $U$2 = start date $U$3 = end date 1 from NETWORKDAYS function means the weekend days are Saturday and Sunday. LIBERE = a named range of holidays / year *8 = work hours / day
To explain how the formula works: - if Z14>0 it means that the person worked in the period from U2 to U3 - NETWORKDAYS.INTL calculates the date difference, minus weekends (1), minus holidays (LIBERE) - then I multiply the result of NETWORKDAYS.INTL (number of working days) with 8 hours / day
Source:
|
|
pus acum 6 ani |
|