Njira ziwiri zosinthira maola kukhala mphindi mu Excel. Momwe mungasinthire maola kukhala mphindi mu Excel

Kwa ena ogwiritsa ntchito pulogalamu ya Excel, pakapita nthawi kumakhala kofunikira kusintha maola kukhala mphindi. Poyamba, zingawoneke kuti ntchito yosavutayi siyenera kuyambitsa zovuta. Komabe, monga momwe zimasonyezera, si aliyense amene angathe kutembenuza maola kukhala mphindi. Izi zimachitika chifukwa chakuti Excel ili ndi ma nuances ake powerengera nthawi. Chifukwa chake, chifukwa cha nkhaniyi, mudzakhala ndi mwayi wodziwa njira zomwe zilipo zomwe zimakupatsani mwayi wosinthira maola kukhala mphindi mu Excel, kuti mutha kuchita izi mwanjira iliyonse yabwino kwa inu.

Zofunikira pakuwerengera nthawi mu Excel

Pulogalamu ya Excel imawerengera nthawi osati ndi kuwerenga kwanthawi zonse kwa ola ndi mphindi, koma kugwiritsa ntchito tsiku. Zikuwoneka kuti Excel imawona 1 ngati maola makumi awiri ndi anayi. Malingana ndi izi, nthawi ya 0,5 yomwe imazindikiridwa ndi pulogalamuyo idzafanana ndi nthawi yomwe munthu amawona pa 12:00, popeza mtengo wa 0.5 umagwirizana ndi sekondi imodzi ya tsiku. Kuti muwone momwe nthawi imawerengedwera pakugwiritsa ntchito, tsatirani izi:

• Sankhani selo iliyonse yomwe mumakonda.
• Patsani selo ili mtundu wa Nthawi.
• Lowetsani mtengo wanthawi.

• Sinthani mtengo wanthawi yolowa kukhala mtundu wa "General".

Mosasamala nthawi yomwe mudalowa m'selo, pulogalamuyo, pambuyo pa zosinthazi, idzamasulira mumtengo womwe udzakhala pakati pa zero mpaka chimodzi. Mwachitsanzo, ngati mutalowa koyamba nthawi yofanana ndi 17:47, ndiye kuti kusintha kukhala mawonekedwe wamba kukupatsani mtengo. 0,740972

Chifukwa chake, potembenuza maola kukhala mphindi mu Excel, ndikofunikira kumvetsetsa momwe pulogalamuyo imawonera nthawi ndikuisintha. Tsopano tiyeni tipite ku kulingalira kwa njira zomwe zilipo kutembenuka.

Kuchulukitsa nthawi ndi chinthu

Imodzi mwa njira zosavuta zosinthira maola kukhala mphindi ndikuchulukitsa nthawi ndi chinthu. Popeza kuti pulogalamu ya Excel imagwira ntchito ndi nthawi pa tsiku, ndikofunikira kuchulukitsa mawu omwe alipo ndi 60 ndi 24, pomwe 60 ndi chiwerengero cha mphindi mu maola, ndipo 24 ndi chiwerengero cha maola pa tsiku. Chifukwa cha kuwerengera uku, timachulukitsa 60 * 24 ndikupeza coefficient yofanana ndi 1440. Podziwa zambiri zamaganizo, tikhoza kupitilira kugwiritsa ntchito njira yomwe ikuganiziridwa.

1. Kuti muchite izi, mu cell pomwe pulogalamuyo iwonetsa zotsatira zomaliza mumphindi, muyenera choyamba kukhazikitsa mtundu wa "General", kenako sankhani ndikuyikamo chizindikiro chofanana.

1. Pambuyo pake, dinani mbewa pa selo lomwe muli chidziwitso mu maola. Mu cell iyi, ikani chizindikiro chochulukitsa ndikulowetsa 1440.

1. Kuti Excel igwiritse ntchito zomwe zalowa ndikuwonetsa zotsatira zake, dinani batani la "Enter". Okonzeka! Pulogalamuyi idatembenuza.

Kugwiritsa ntchito chizindikiro chomaliza

Nthawi zambiri, ogwiritsa ntchito amafunika kusintha ndi kuchuluka kwa data. Pankhaniyi, ndi bwino kugwiritsa ntchito chogwirira chodzaza.

1. Kuti muchite izi, ikani cholozera cha mbewa kumapeto kwa selo ndi ndondomekoyi.
2. Dikirani masekondi angapo kuti chogwirira chodzaza chitsegule ndipo muwona mtanda.
3. Mukatsegula chikhomo, gwirani batani lakumanzere ndikukokera cholozera chofanana ndi ma cell ndi nthawi yoti atembenuke.

1. Kenako mudzawona bwino kuti zikhalidwe zonse zidzasinthidwa ndi pulogalamuyi kukhala mphindi.

Sinthani pogwiritsa ntchito ntchito yophatikizika mu Excel

Njira yachiwiri yosinthira ndiyo kugwiritsa ntchito ntchito yapadera ya CONVERT, yomwe imaphatikizidwa mu pulogalamu ya Excel yokha.

Chonde dziwani kuti njirayi ingagwiritsidwe ntchito ngati maselo otembenuzidwa ali ndi nthawi mumtundu wamba. Mwachitsanzo, nthawi 12 koloko iyenera kulembedwa ngati "12" ndipo nthawi 12:30 iyenera kulembedwa ngati "12,5".

1. Kuti mugwiritse ntchito njirayi, muyenera kusankha selo lomwe mukufuna kuwonetsa zotsatira.

1. Kenako pazenera lapamwamba la pulogalamuyi muyenera kupeza chinthu cha menyu chotchedwa "Insert function". Mukadina chinthucho menyu, zenera latsopano lidzatsegulidwa patsogolo panu. Zenerali liwonetsa mndandanda wazinthu zonse zophatikizidwa mu pulogalamu ya Excel.
2. Poyang'ana mndandanda wa ntchito pogwiritsa ntchito slider, pezani ntchito yotchedwa CONV. Ndiye muyenera kusankha izo ndi kumadula "Chabwino" batani.

1. Zenera lotsatira lidzawonekera kutsogolo kwanu, momwe magawo atatu a mikangano ya ntchito yosankhidwa adzawonetsedwa. Monga mtsutso woyamba, muyenera kutchula nambala ya nthawiyo kapena mawu okhudzana ndi selo lomwe mtengowu uli. Tchulani maola mugawo lachiwiri la mkangano, ndi mphindi mu gawo lachitatu la mkangano.
2. Pambuyo adalowa onse deta, dinani "Chabwino" batani. Mukadina batani ili, pulogalamuyo idzawonetsa zotsatira mu cell yomwe mwasankha.

Ngati mukufuna kugwiritsa ntchito ntchito ya CONVERT kuti musinthe ma data, mutha kugwiritsa ntchito chikhomo chodzaza, kuyanjana komwe kwafotokozedwa pamwambapa.

Kutsiliza

Pomaliza, ziyenera kudziwidwa kuti popeza mwadziwa njira ziwiri zosinthira maola kukhala mphindi mu Excel, mutha kusankha njira yabwino kwambiri komanso yabwino yomwe ikugwirizana ndi zosowa zanu.