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:
mememe12
Femeie
23 ani
Bucuresti
cauta Barbat
23 - 80 ani
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] Working Hours in Period-Weekends-Holidays-Personal Days Moderat de TRaP, TonyTzu
Autor
Mesaj Pagini: 1
TRaP
Moderator

Inregistrat: acum 7 ani
Postari: 801
=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
   
Pagini: 1  

Mergi la