Helu helu hola ma Excel

E aʻo mai kēia hiʻohiʻona iā ʻoe pehea e hana ai i kahi helu helu maʻalahi ma Excel. ʻO nā pūnaewele i loaʻa nā ʻōhumu he kala melemele māmā.

  1. No ka helu ʻakomi ʻana i nā lā 4 aʻe ma hope o ka lā hoʻomaka, e hoʻohana i nā ʻōkuhi ma lalo nei:
    • No ke kelepona B6:

      =TEXT(C6,"dddd")

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

    • No ke kelepona C6:

      =C5+1

  2. E koho i nā pūnaewele i loaʻa ka manawa.
  3. E kaomi ʻākau iā lākou, ma ka papa kuhikuhi koho Nā Kelepona Hōʻike (Cell Format) a hoʻonohonoho i ka hōʻano manawa kūpono. No nā pūnaewele R-12, R-13 и R-14 e hoʻohana i ke ʻano i hoʻopuni ʻia ma ke kiʻi ma lalo nei.
  4. No ka helu 'akomi i kēlā me kēia lā o nā hola hana, a me ka nui o nā hola a me nā manawa keu, e hoʻohana i nā ʻōkuhi ma lalo nei:
    • No ka laula K5: K9:

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

    • No ke kelepona R-12:

      =SUM(K5:K9)

      =СУММ(K5:K9)

    • No ke kelepona R-14:

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

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

Waiho i ka Reply