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.
|
Nou pe simpatie:
Andreea_K din Caras Severin
 | Femeie
25 ani
Caras Severin
cauta Barbat
30 - 49 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 960
|
|
=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:
https://exceljet.net/excel-functions/ex ... l-function
|
|
| |
|
