Tsiku panopa. Momwe tsiku panopa ndi nthawi mu kupambana

Excel ndi bungwe "Microsoft" ndi purosesa amphamvu kwambiri amene facilitates ogwiritsa angapo ntchito tsiku ndi yambiri deta tabular. Komabe, ngakhale anakumana akatswiri, zaka zambiri ntchito ndi pulogalamu imeneyi, nthawi zina yotayika kufunika amaika mu fomu selo tsiku panopa ndi nthawi. Izi zili choncho makamaka chifukwa chakuti ntchito "Tsiku", kuti ilo kwanzeru ntchito kupeza mfundo kufunika, amachita ntchito chosiyana. M'nkhaniyi, ife tinena za mitundu yosiyanasiyana ya zipatso ntchito kupambana, kuti njira kukonzekera ndi ntchito yawo mbali.

mitundu ya zipatso

Excel akulingalira yachiwiriyo "Tsiku panopa". The oyamba - ichi ndi kuliika mtengo wa tsiku panopa ndi nthawi, kompyuta wosuta za mnzanuyo. Kamodzi adalowa fomu ndi yofunika sisintha kaya kusintha mu nthawi yeniyeni ndi tsiku. Pamene mungafunike njirayi? mayankho ambiri Mwachitsanzo, pamene sitolo tsiku kulandira wantchito ntchito kapena kuchotsedwa, kulowa tsiku chiphaso cha katundu ndi nyumba yosungiramo katundu. mfundo imeneyi iyenera kukhala malo amodzi, chifukwa iwo sasintha ndi kupita kwa nthawi.

Baibulo lachiwiri la "Tsiku pano" - ndi wochitachita, zimasintha, updateable. The ntchito ambiri njirayi - tsiku ndi nthawi phindu mu ngodya ya fomu, monga mbali ya lolembedwa ndi "Lero, May 14, 2017". zosinthika ichi chimagwiritsidwa ntchito mitunduyi Mwachitsanzo kuwerengera masiku angati kuchokera ku nambala inayake. Ogwira Choncho kuphunzira anayenda kupita kumeneko ndi mapeto a nthawi probationary wantchito, ndi cheke wantchito katundu, osati kaya tsiku lotha mu KATUNDU lapansi.

Kumene, tsiku zazikulu ndi nthawi mu kupambana ndi zothandiza, koma pali chinthu chofunika kwambiri: mosalekeza updating amatsogoza deta zimachokeradi. Mtengo analowa idzasintha pamene anatsegula m'buku lakuti, pamene zazikulu mu mawerengedwe a maikwezhoni zosiyanasiyana. Ngati inu ndingozisiya bukhu lotseguka, ndipo palibe zimene pamwamba adzachita, tsiku ndi nthawi tidzakhalabe ndi zimene mwalowa kamodzi. Koma m'pofunika kuti adzathe kutsegula buku kapena recalculate kachitidwe, mfundo adzakhala kusinthidwa.

Taganizirani mmene kupambana amaika awa mitundu iwiri ya zipatso.

Tsiku lokhazikika, musati zosinthika

mtengo Excel "panopa tsiku" akhoza zopezera basi kukanikiza ndi Ctrl ofunika kwambiri, ndipo ";". Ingoimirirani pa foni analakalaka fomu ndipo nthawi yomweyo yokokera pansi pa Ctrl ofunika akanikizire semicolon. Selo kudzakhala tsiku ziliri pa mtundu lalifupi, mwachitsanzo 5/14/2017.

Amaika nthawi, kuchita ntchito zofanana ndi atagwira pansi Ctrl makiyi, dinani ndi kugwira pansi chinsinsi Kaonedwe ndi chabe akanikizire semicolon. Onse. Amaika nthawi panopa mu mtundu "hh: mamilimita".

Kusunga muchipindachi pomwepo ndi tsiku ndi nthawi yokwanira ndikatha kulowetsa tsiku ndi akanikizire spacebar amaika nthawi, ntchito mwachindunji Simungachite kiyi.

Monga tikuonera, kumanga kwa apano tsiku atathana mtundu mu kupambana n'kosavuta. Anachitazi yekha ndiye kuti m'pofunika pa keyboards kwambiri popanda makiyi zina, kusinthana kwa English Kamangidwe kiyibodi.

Tsiku pompopompo kusinthidwa

tsiku Current mu mawonekedwe a updatable akufotokozera kupambana ntchito mitunduyi. Njira ziwiri:

• Chilinganizo "= TODAY ()" amalola kuti tsiku panopa.
• Chilinganizo "= TSOPANO ()" amalola kuti tsiku panopa ndi nthawi.

ntchito Amenewa alibe mfundo komanso mfundo analandira ntchito iwo kusinthidwa nthawi iliyonse zochokera / buku / kukoka mitunduyi kapena kukonzanso kutsegula kwa pepalalo.