Limodzi mwa magulu odziwika kwambiri omwe amagwira ntchito ndi matebulo a Excel ndi tsiku ndi ntchito nthawi. Ndi thandizo lawo kuti zosintha zingapo zomwe zili ndi data yakanthawi zitha kuchitika. Tsiku ndi nthawi zimasindikizidwa pakupanga mitengo yambiri mu Excel. Kuti muwunikire izi ndi ntchito yayikulu ya omwe ali pamwambapa. Tiyeni tiwone komwe mungapeze ntchito izi pagulu la pulogalamuyi, komanso momwe mungagwiritsire ntchito njira zamtunduwu.
Gwirani ntchito ndi tsiku ndi nthawi
Gulu ndi nthawi yogwirira ntchito ndi yomwe imayang'anira kusanthula kwa deta yomwe yaperekedwa munthawi ya mtundu kapena nthawi. Pakadali pano opareshoni opitilira 20 mu Excel omwe ali m'gulu lapa formula. Ndi kutulutsidwa kwa mitundu yatsopano ya Excel, ziwerengero zawo zikuchulukirachulukira.
Ntchito iliyonse ikhoza kutumizidwa pamanja ngati mukudziwa mawonekedwe ake, koma ogwiritsa ntchito ambiri, osadziwa zambiri kapena omwe ali ndi chidziwitso chosaposa kuchuluka, ndizosavuta kuyika malamulo kudzera pazithunzi zoponyedwa Ntchito wiz kutsatira kusunthira pazenera zotsutsana.
- Kuyambitsa chilinganizo Fotokozerani Wizard sankhani khungu komwe zotsatira zikuwonetsedwa, kenako dinani batani "Ikani ntchito". Ili kumanzere kwa baramu ya formula.
- Pambuyo pake, Wizard Yogwira Ntchito imayambitsidwa. Dinani pamunda Gulu.
- Kuchokera pamndandanda womwe umatsegulira, sankhani "Tsiku ndi nthawi".
- Pambuyo pake, mndandanda wa ogwiritsa ntchito gululi amatsegulidwa. Kuti mupite ku inayake, sankhani ntchito yomwe mudzafuna ndikudina batani "Zabwino". Pambuyo pochita izi pamwambapa, zenera zotsutsana zidzayambitsidwa.
Komanso Fotokozerani Wizard imatha kutsegulidwa posankha khungu papepala ndikusindikizira kuphatikiza kiyi Shift + F3. Pali mwayi woti mupite ku tabu Mawonekedwekomwe ndi nthiti mu gulu lazida Laibulale ya Feature dinani batani "Ikani ntchito".
Ndikotheka kusunthira pawindo mfundo zamagulu ena kuchokera pagulu "Tsiku ndi nthawi" osayambitsa iwindo lalikulu la Ntchito Wizard. Kuti muchite izi, pitani ku tabu Mawonekedwe. Dinani batani "Tsiku ndi nthawi". Amayikiridwa ndi riboni m'gulu la zida. Laibulale ya Feature. Mndandanda wa ogwiritsira ntchito omwe ali mgululi amachitidwa. Sankhani zomwe zikufunika kuti mumalize ntchitoyo. Pambuyo pake, zotsutsana zimasunthira pazenera.
Phunziro: Ntchito Wizard ku Excel
DATE
Chimodzi mwa zosavuta koma nthawi yomweyo zomwe gulu limafuna ndikuchita DATE. Ikuwonetsa tsiku lomwe linaperekedwa mu mawonekedwe amumelo mu khungu momwe formula imakhalapo.
Zotsutsana zake ndi "Chaka", "Mwezi" ndi "Tsiku". Gawo lazosintha deta ndikuti ntchitoyo imagwira ntchito ndi nthawi osati koyambirira kwa 1900. Chifukwa chake, ngati kukangana m'munda "Chaka" khazikitsani, mwachitsanzo, 1898, wothandizira adzawonetsa mtengo wolakwika mu cell. Mwachilengedwe, ngati mikangano "Mwezi" ndi "Tsiku" manambala kuyambira 1 mpaka 12 ndi 1 mpaka 31. Zomwe zimaphatikizidwa ndi maulalo omwe amapezeka m'maselo omwe ali ndi zomwe zikugwirizana zingathenso kukhala mfundo.
Kuti mwakhazikitse pamanja, gwiritsani ntchito izi:
= DATE (Chaka; Mwezi; Tsiku)
Ogwiritsa ntchito ali pafupi ndi ntchitoyi pamtengo CHAKA, MWEZI ndi TSIKU. Amatulutsa mtengo womwe ungafanane ndi dzina lawo m'chipindacho ndipo amasemphana dzina limodzi.
HAND
Mtundu wapadera ndi wothandizira HAND. Imawerengetsa kusiyana pakati pa masiku awiri. Mbali yake ndikuti othandizira sakhala mndandanda wazinthu Ogwira Ntchito, zomwe zikutanthauza kuti mfundo zake nthawi zonse siziyenera kulembedwa osati kudzera pazithunzi, koma pamanja, kutsatira izi:
= DATE (kuyamba_dikidwani; kumapeto_dongosolo; gawo)
Ndizachidziwikire kuti monga mfundo "Tsiku loyambira" ndi Tsiku lomaliza masiku amawonekera, kusiyana pakati pa zomwe zikuyenera kuwerengedwa. Koma monga mkangano "Gulu" amayimira gawo lenileni la muyeso wa kusiyana uku:
- Chaka (y)
- Mwezi (m);
- Tsiku (d)
- Kusiyana m'miyezi (YM);
- Kusiyana kwa masiku kupatula zaka (YD);
- Kusiyana kwa masiku kupatula miyezi ndi zaka (MD).
Phunziro: Chiwerengero cha masiku pakati pa masiku ku Excel
NETWORKS
Mosiyana ndi wothandizira wakale, fomula NETWORKS zalembedwa Ogwira Ntchito. Ntchito yake ndikuwerenga kuchuluka kwa masiku ogwira ntchito pakati pa masiku awiri omwe amatchulidwa kuti amatsutsana. Kuphatikiza apo, pali mkangano wina - "Tchuthi". Mkanganowu ndi wosankha. Zimawonetsa kuchuluka tchuthi cha nthawi yowerengera. Masiku awa amathandizidwanso pamawerengero onse. Fomuloli amawerengera kuchuluka kwa masiku pakati pa masiku awiri, kupatula Loweruka, Lamlungu, ndi masiku omwe osankhidwa ndi tchuthi amakhala. Zotsutsana zingakhale masiku omwe kapena zonena za ma cell omwe zilimo.
Chingwe chimawoneka motere:
= NET (kuyamba_dikidwani; kumapeto_ kumapeto; [maholide])
TDATA
Wogwiritsa ntchito TDATA chosangalatsa chifukwa chilibe kutsutsana. Zimawonetsa tsiku ndi nthawi yomwe zili pa kompyuta mu foniyo. Tiyenera kudziwa kuti mtengowu sudzangosintha wokha. Imakhala yokhazikika panthawi yomwe ntchitoyo imapangidwira mpaka itapangidwanso. Kuti musinthe mtundu, ingosankha foni yomwe ili ndi ntchitoyo, ikani cholozera mu barula yamuyo ndikudina batani Lowani pa kiyibodi. Kuphatikiza apo, kuwerengedwa kangapo kwa chikalata kumatha kuthandizidwa muzokonza zake. Syntax TDATA monga:
= DATE ()
LERO
Wogwiritsa ntchito ali wofanana kwambiri ndi ntchito yapita mu mphamvu zake LERO. Alibe mikangano. Koma khungu silikuwonetsa mwachidule za tsiku ndi nthawi, koma tsiku limodzi lokha. Syntax ndilosavuta kwambiri:
= LERO ()
Ntchitoyi, monga yapita, imafuna kusinthidwa kuti ikonzedwe. Kubwezeretsa kumachitika chimodzimodzi.
NTHAWI
Cholinga chachikulu cha ntchitoyo NTHAWI ndiye kutulutsa kwa foni yoperekedwa nthawi yotsimikizidwa ndi mfundo. Zotsutsana ndi ntchitoyi ndi maola, mphindi, ndi masekondi. Zitha kutchulidwa mokhazikika pamapangidwe amomwe amaunikira komanso momwe zimalumikizirana ndi ma cell omwe zimasungidwa izi. Ntchitoyi ndi yofanana kwambiri ndi wothandizira. DATE, kokha mosiyana ndi iyo imawonetsa zowonetsa nthawi. Mtengo wotsutsana Penyani zitha kufotokozedwa pamtunda kuchokera pa 0 mpaka 23, ndipo zotsutsana pamphindi ndi chachiwiri - kuchokera pa 0 mpaka 59. Mawu akuti:
= NTHAWI (Maola; mphindi; masekondi)
Kuphatikiza apo, pafupi ndi opaleshoni iyi imatha kutchedwa ntchito payekha HARA, Maminiti ndi Masekondi. Amawonetsa mtengo wofanana ndi dzina la chisonyezo cha nthawi, chomwe chimaperekedwa ndi lingaliro limodzi la dzina lomweli.
DATEVALUE
Ntchito DATEVALUE zachindunji. Sichikonzedwera anthu, koma pulogalamuyo. Ntchito yake ndikusintha mbiri yakale kukhala yodziwika kuti ikhale nambala imodzi yokha, yopezeka ku Excel. Chokhacho chotsutsana ndi ntchitoyi ndi tsiku monga malembedwe. Komanso, monga momwe ziliri ndi mkangano DATE, mitengo yokha pambuyo pa 1900 imakonzedwa bwino. Syntax ndi motere:
= DATEVALUE (deti_ lingaliro)
TSIKU
Ntchito yothandizira TSIKU - onetsani mu khungu lomwe mwasankhalo mtengo wa tsiku la sabata pa tsiku lopatsidwa. Koma fomuloli silikuwonetsa dzina latsikulo, koma nambala ya seri yake. Komanso, gawo loyang'ana tsiku loyamba la sabata lakhazikitsidwa m'munda "Mtundu". Chifukwa chake, ngati mungakhazikitse phindu pankhaniyi "1"ndiye Lamlungu lidzalingaliridwa kukhala tsiku loyamba la sabata ngati "2" - monday, etc. Koma uku sikuti ndi kukakamizidwa kukakamira, ngati mundawo sunadzazidwe, ndiye kuti amawerengera kuyambira Lamlungu. Mtsutso wachiwiri ndiye tsiku lenileni la mawerengero, tsiku lomwe liyenera kukhazikitsidwa. Chingwe chimawoneka motere:
= TSIKU (Date_in_numeric_format; [Mtundu])
MABUKU
Komwe ophunzirawo amapita MABUKU ndiye chisonyezo mu foni yoperekedwa ya nambala ya sabata pofika tsiku loyambirira. Zotsutsana ndi tsiku lenileni komanso mtundu wobwerera. Ngati zonse zili zomveka ndi mkangano woyamba, ndiye chachiwiri chimafunikira kufotokozera kwina. Chowonadi ndi chakuti m'maiko ambiri aku Europe malinga ndi miyezo ya ISO 8601, sabata loyamba la chaka limawonedwa ngati sabata yomwe imagwera Lachinayi loyamba. Ngati mukufuna kugwiritsa ntchito dongosolo lazowonetserazi, ndiye kuti mu mtundu wamtundu womwe muyenera kuyika manambala "2". Ngati mukufuna chizolowezi chomudziwa bwino, komwe sabata yoyamba ya chaka ndi yomwe imagwera pa Januware 1, ndiye muyenera kuyika chithunzi "1" kapena siyani mundawo wopanda kanthu. Syntax yantchito ndi iyi:
= Masabata (tsiku; [mtundu])
ZOTHANDIZA
Wogwiritsa ntchito ZOTHANDIZA amawerengera pachidutswa cha chaka chomwe chimatsirizidwa pakati pa masiku awiri pachaka chonse. Zotsutsana ndi ntchitoyi ndi masiku awiriwa, omwe ndi malire a nthawi. Kuphatikiza apo, ntchitoyi ili ndi malingaliro osankha. "Maziko". Zimawonetsa njira yowerengera tsikulo. Mwachisawawa, ngati palibe phindu lomwe lafotokozedwa, njira yowerengera yaku America imatengedwa. Nthawi zambiri, zimakhala zolondola, nthawi zambiri mkangano uwu suyenera kudzazidwa konse. Syntax amatenga mawonekedwe otsatirawa:
= DEBT (chiyambi_katikati; kumapeto_dilesi; [maziko])
Tinadutsa okhawo oyendetsa omwe amapanga gulu la ntchito "Tsiku ndi nthawi" mu Excel. Kuphatikiza apo, pali opitilira ena oposa khumi ndi awiri a gulu lomweli. Monga mukuwonera, ngakhale ntchito zomwe tafotokozazi zimathandizira kuti ogwiritsa ntchito azigwiritsa ntchito mawonekedwe amtunduwu monga tsiku ndi nthawi. Zinthu izi zimakupatsani mwayi kusinthira kuwerengera kwina. Mwachitsanzo, ndikulowa tsiku kapena nthawi yomwe ilili mu foni yotsimikizidwa. Popanda kudziwa kuyang'anira ntchitozi, munthu sangathe kunena za Excel.
