Maawa akashanda Calculator muExcel

Uyu muenzaniso unokudzidzisa maitiro ekugadzira yakapusa hurongwa Calculator muExcel. Masero ane mafomula ane ruvara rweyero.

1. Kuti uverenge otomatiki mazuva mana anotevera mushure mezuva rekutanga, shandisa mafomula ari pazasi:
   • Yesero B6:

     =TEXT(C6,"dddd")

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

   • Yesero C6:

     =C5+1

2. Sarudza maseru ane nguva.
3. Tinya-kurudyi pavari, mumenu yemukati sarudza Fomati Masero (Sero Format) uye isa iyo chaiyo nguva fomati. Zvemasero R-12, R-13 и R-14 shandisa chimiro chakatenderedzwa mumufananidzo uri pazasi.
4. Kwemazuva ese otomatiki kuverenga kwemaawa anoshandiswa, pamwe neawa yakazara uye nguva yakawandisa, shandisa mafomula ari pazasi:
   • For range K5: k9:

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

   • Yesero R-12:

     =SUM(K5:K9)

     =СУММ(K5:K9)

   • Yesero R-14:

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

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