Awanni aiki kalkuleta a cikin Excel

Wannan misalin zai koya muku yadda ake ƙirƙira madaidaicin lissafin jadawalin a cikin Excel. Kwayoyin da ke ɗauke da dabara suna launin rawaya mai haske.

1. Don lissafta ta atomatik kwanaki 4 masu zuwa bayan ranar farawa, yi amfani da dabarun da ke ƙasa:
   • Don tantanin halitta B6:

     =TEXT(C6,"dddd")

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

   • Don tantanin halitta C6:

     =C5+1

2. Zaɓi sel ɗin da ke ɗauke da lokaci.
3. Danna-dama akan su, a cikin mahallin menu zaɓi Tsarin Sel (Format cell) kuma saita tsarin lokaci daidai. Don sel R-12, R-13 и R-14 yi amfani da tsarin da aka kewaye a cikin hoton da ke ƙasa.
4. Don lissafin sa'o'i na atomatik na yau da kullun da aka yi aiki, da kuma jimlar sa'o'i da kari, yi amfani da dabarun da ke ƙasa:
   • Don kewayo ku 5:k9:

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

   • Don tantanin halitta R-12:

     =SUM(K5:K9)

     =СУММ(K5:K9)

   • Don tantanin halitta R-14:

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

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