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:
pissy_kitty
 | Femeie
24 ani
Sibiu
cauta Barbat
24 - 48 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 748
|
|
=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 5 ani |
|