Zofunikira zogwirira ntchito ndi masiku ndi nthawi mu Excel

Video

Monga mwachizolowezi, ndani ayenera mwamsanga - penyani kanema. Tsatanetsatane ndi ma nuances - muzolemba pansipa:

Momwe mungayikitsire masiku ndi nthawi mu Excel

If we keep in mind the regional settings, then Excel allows you to enter the date in very different ways – and understands them all:

Maonekedwe (mawonekedwe) a deti mu cell amatha kukhala osiyana kwambiri (okhala kapena opanda chaka, mwezi ngati nambala kapena mawu, ndi zina zambiri) ndipo amayikidwa pamindandanda yankhani - dinani kumanja pa cell ndiyeno Mawonekedwe a cell (Maselo a Format):

Nthawi imalowetsedwa m'maselo pogwiritsa ntchito ma colon. Mwachitsanzo

16:45

Ngati mungafune, mutha kufotokozeranso kuchuluka kwa masekondi - kuwalowetsanso olekanitsidwa ndi colon:

16:45:30

Ndipo, potsiriza, palibe amene amaletsa kufotokoza tsiku ndi nthawi mwakamodzi pamodzi kupyolera mu danga, ndiko 

27.10.2012 16: 45

Kulowa mwachangu masiku ndi nthawi

Kuti mulowetse deti lamakono mu cell yomwe ilipo, mutha kugwiritsa ntchito njira yachidule ya kiyibodi Ctrl + Ж (kapena CTRL+SHIFT+4 ngati muli ndi chilankhulo china chosasinthika).

Ngati inu kukopera selo ndi deti (koka kuchokera kumunsi kumanja ngodya ya selo), akugwira Chabwino batani la mbewa, mutha kusankha momwe mungakopere tsiku lomwe mwasankha:

Ngati nthawi zambiri mumayenera kuyika masiku osiyanasiyana m'maselo a pepala, ndiye kuti ndizosavuta kuchita izi pogwiritsa ntchito kalendala yotulukira:

Ngati mukufuna kuti selo likhale ndi tsiku lenileni la lero, ndi bwino kugwiritsa ntchito ntchitoyi TODAY (LERO):

Momwe Excel imasungira ndikusintha masiku ndi nthawi

Ngati mungasankhe selo yokhala ndi tsiku ndikuyiyika General format (dinani pomwe pa cell Mawonekedwe a cell – tabu Number - General), mutha kuwona chithunzi chosangalatsa:

Ndiye kuti, kuchokera pakuwona kwa Excel, 27.10.2012/15/42 41209,65417:XNUMX pm = XNUMX

M'malo mwake, Excel imasunga ndikusintha tsiku lililonse chimodzimodzi - monga nambala yokhala ndi gawo limodzi ndi gawo laling'ono. Gawo lalikulu la chiwerengerocho (41209) ndi chiwerengero cha masiku omwe adutsa kuyambira pa Januwale 1, 1900 (atengedwa ngati malo owonetsera) mpaka lero. Ndipo gawo laling'ono (0,65417), motsatana, gawo latsiku (tsiku limodzi = 1)

Kuchokera ku mfundo zonsezi pali mfundo ziwiri zothandiza:

• Choyamba, Excel silingagwire ntchito (popanda makonda owonjezera) ndi madeti asanafike Januware 1, 1900. Koma tipulumuka izi! 😉
• Kachiwiri, ndizotheka kuchita masamu aliwonse okhala ndi masiku ndi nthawi mu Excel. Ndendende chifukwa iwo kwenikweni manambala! Koma izi zimatsegula kale mwayi wambiri kwa wogwiritsa ntchito.

Chiwerengero cha masiku pakati pa madeti awiri

Kumatengedwa ngati kuchotsera kosavuta - timachotsa tsiku loyamba kuchokera pa tsiku lomaliza ndikumasulira zotsatira zake General (General) mtundu wa nambala kuti uwonetse kusiyana kwa masiku:

Chiwerengero cha masiku a ntchito pakati pa masiku awiri

Apa zinthu ndizovuta kwambiri. Loweruka, Lamlungu ndi tchuthi siziyenera kuganiziridwa. Pakuwerengera koteroko, ndi bwino kugwiritsa ntchito ntchitoyi NTCHITO WOYERA (NETWORKDAYS) kuchokera mgulu Tsiku ndi Nthawi. Monga zotsutsana ndi ntchitoyi, muyenera kutchula masiku oyambira ndi omaliza ndi masiku omwe ali ndi masiku a sabata (tchuthi, masiku odwala, tchuthi, masiku opuma, ndi zina zotero):

Zindikirani: Ntchitoyi yawoneka muzochita zokhazikika za Excel kuyambira mtundu wa 2007. M'matembenuzidwe akale, muyenera choyamba kulumikiza zowonjezera Phukusi la kusanthula. Kuti muchite izi, pitani ku menyu Service - Zowonjezera (Zida - Zowonjezera) ndipo fufuzani bokosi pafupi Analysis phukusi (Analisys Toolpak). Pambuyo pake, mu Function Wizard mu gulu Tsiku ndi Nthawi ntchito yomwe tikufuna idzawonekera NTCHITO WOYERA (NETWORKDAYS).

Chiwerengero cha zaka, miyezi, ndi masiku athunthu pakati pa madeti. Zaka mu zaka. Zochitika.

Za momwe mungawerengere molondola, ndi bwino kuwerenga apa.

Sinthani tsikulo ndi masiku odziwika

Popeza tsiku limodzi mu Excel date reference system imatengedwa ngati unit (onani pamwambapa), kuwerengera tsiku lomwe ndiloti, masiku 20 kutali ndi lomwe laperekedwa, ndikwanira kuwonjezera nambalayi ku tsikulo.

Sinthani tsikulo ndi chiwerengero cha masiku a ntchito

Ntchitoyi ikuchitika ndi ntchitoyo TSIKU LA NTCHITO (TSIKU LA NTCHITO). Zimakupatsani mwayi wowerengera tsiku lomwe likupita patsogolo kapena kubwerera kumbuyo ndi tsiku loyambira ndi kuchuluka kwamasiku ogwirira ntchito (poganizira Loweruka ndi Lamlungu ndi maholide). Kugwiritsiridwa ntchito kwa chipangizo ichi ndikofanana ndi kugwiritsira ntchito NTCHITO WOYERA (NETWORKDAYS) zafotokozedwa pamwambapa.

Kuwerengera tsiku la sabata

Simunabadwe Lolemba? Ayi? Zedi? Ikhoza kufufuzidwa mosavuta ndi ntchito TSIKU (WEEKTDAY)kuchokera mgulu Tsiku ndi Nthawi.

Mtsutso woyamba wa ntchitoyi ndi selo yokhala ndi deti, yachiwiri ndi mtundu wa kuwerengera masiku a sabata (yosavuta kwambiri ndi 2).  

Mawerengedwe a nthawi intervals

Popeza nthawi mu Excel, monga tafotokozera pamwambapa, ndi nambala yofanana ndi deti, koma gawo lake lokhalokha, ndiye kuti masamu aliwonse amathanso kukhala ndi nthawi, monga ndi tsiku - kuwonjezera, kuchotsa, ndi zina zotero.

Pali nuance imodzi yokha apa. Ngati, powonjezera nthawi zingapo, kuchuluka kwake kudakhala kopitilira maola 24, ndiye kuti Excel idzayambiranso ndikuyambanso kuwerengeranso kuchokera paziro. Kuti izi zisachitike, muyenera kugwiritsa ntchito mawonekedwewo ku selo yomaliza 37:30:55:

• Momwe mungawerengere zaka (zochitikira) muzaka zonse-miyezi-masiku
• Momwe mungapangire kalendala yotsitsa kuti mulowe mwachangu tsiku lililonse mu cell iliyonse.
• Onjezani zokha tsiku lomwe lilipo pa cell polowetsa data.
• Momwe mungawerengere tsiku la Lamlungu lachiwiri mu February 2007, ndi zina.