Saacadaha ku shaqeeya xisaabiyaha Excel

Tusaalahan ayaa ku bari doona sida loo sameeyo xisaabiyaha jadwal fudud ee Excel. Unugyada ka kooban qaababku waa huruud khafiif ah.

1. Si aad si toos ah u xisaabiso 4ta maalmood ee soo socota ka dib taariikhda bilawga, isticmaal hababka hoose:
   • Unug B6:

     =TEXT(C6,"dddd")

     =ТЕКСТ(C6;"дддд")

   • Unug C6:

     =C5+1

2. Dooro unugyada wakhtiga ku jira.
3. Midig ku dhufo iyaga, menu-ka macnaha guud dooro Unugyada qaab (Qaabka gacanta) oo deji qaabka wakhtiga saxda ah. Unugyada R-12, R-13 и R-14 isticmaal qaabka ku wareegsan sawirka hoose.
4. Xisaabinta tooska ah ee maalinlaha ah ee saacadaha la shaqeeyay, iyo sidoo kale wadarta saacadaha iyo saacadaha dheeraadka ah, isticmaal hababka hoose:
   • Qiyaas ahaan K5: K9:

     =(F5-E5)+(I5-H5)

   • Unug R-12:

     =SUM(K5:K9)

     =СУММ(K5:K9)

   • Unug R-14:

     =IF(K12>K13,K12-K13,0)

     =ЕСЛИ(K12>K13;K12-K13;0)