Ukungena kwixesha nge-DATE Umsebenzi kwi-Google Spreadsheets

Ixesha lokukhusela Iimpazamo kwiifomu ezisetyenziswa ngomhla we-DATE Umsebenzi

Imihla kunye noMHLA Umsebenzi Umsebenzi

Umsebenzi we-Google Spreadsheet yomhla we-DATE uza kubuya umhla okanye inombolo yecala yomhla ngokuhlanganisa usuku ngalunye, inyanga kunye neminyaka ezifakelwe njengeengxoxo zomsebenzi.

Umzekelo, ukuba umsebenzi we-DATE olandelayo ungeniswe kwiseli yomsebenzi,

= UMHLA (2016,01,16)

inombolo ye-serial 42385 ibuyiselwe, ebhekisela kumhla kaJanuwari 16, 2016.

Ukutshintsha iiNombolo zeNombolo ukuya kwiiDati

Xa zifakwe ngokwazo - njengoko ziboniswe kwiseli D4 kumfanekiso ongentla, inombolo ye-serial ifomathiwe ukuba ibonise umhla. Amanyathelo adingekayo ukufezekisa lo msebenzi abhalwe apha ngezantsi xa kufuneka.

Ukungena kwixesha njengeeDates

Xa zidibene nezinye i-Google Spreadsheet imisebenzi , umhla we-DATE ungasetyenziselwa ukuvelisa iindidi ezahlukeneyo zeemfomula njengoko kuboniswe kumfanekiso ongentla.

Ukusetyenziswa okubalulekileyo komsebenzi - njengoko kuboniswe kwimigangatho emi-5 ukuya kweyesi-10 kumfanekiso ongentla-kukuqinisekisa ukuba imihla ingeniswe kwaye isichazwa ngokuchanekileyo ngamanye emisebenzi yomhla we-Google Spreadsheet. Oku kuyinyani ngokukodwa ukuba idatha efakweyo ifomathiwe njengombhalo.

Umsebenzi we-DATE usetyenziswa ngokukodwa:

• ukubonisa usuku oludibanisa izinto zonyaka - njengonyaka, inyanga, okanye imini ukusuka kwiindawo ezahlukeneyo kwiphepha lokusebenzela
• ukuqinisekisa ukuba imihla esetyenzisiweyo ekubaleni iguqulelwa njengemihla (idatha yedatha) endaweni yesetekisi yedatha

UMHLA WOMSEBENZI Umsebenzi & # 39; ii-Syntax kunye neeArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano.

I-syntax yomsebenzi we-DATE ngu:

= UMHLA (unyaka, inyanga, imini)

unyaka - (efunekayo) faka unyaka njengenombolo yeenombolo ezine (yyyy) okanye iselferensi yesalathisi kwindawo yalo kwiphepha lokusebenzela

inyanga - (efunekayo) faka inyanga njengeenombolo ezimbini zamanqaku (mm) okanye isalathisi yesalathisi kwindawo yayo kwiphepha lokusebenzela

imini - (efunekayo) faka umhla njengeenombolo ezimbini zamanani (dd) okanye iselferensi yesalathisi kwindawo yalo kwiphepha lokusebenzela

• #VALUE! Ixabiso lephutha libuyiselwa ngumsebenzi ukuba idatha yombhalo ingeniswe esikhundleni senombolo - oku kubandakanya ukufaka isalathiso kweseli equkethe isicatshulwa
• #NUM! Ixabiso lephutha libuyiselwa ngumsebenzi ukuba inani leenombolo ezintlanu - ezifana ne-20016 - lingeniswa kwingxabano yonyaka
• ukuba ixabiso elingavumelekanga kwinyanga okanye kwiingxabano zemihla, umsebenzi ulungisa ngokuzenzekelayo umkhiqizo womsebenzi ukuya kumhla ovumelekileyo ozayo. Umzekelo,
  • = UMHLA (2016,13,1) - unama-13 kwingxabano yenyanga - iguqula ingxabano yonyaka kunye ne-1/1/2017
  • = UMHLA (2016,01,32) - unemihla engama-32 kwenyanga kaJanuwari - ulungelelanisa ingxabano yenyanga kwaye ubuye u-2/01/2016
• ukuba ixabiso lokugqibela lifakwe kwingxabano, ixabiso lithathwa kwixabiso elipheleleyo. Ngokomzekelo, ixabiso "10.25" liza kuhunyushwa ngokuthi "10" ngumsebenzi

UMHLA Umsebenzi Umzekelo

Kulo mfanekiso ungentla, umsebenzi we-DATE usetyenziswa ngokubambisana nenani leminye imisebenzi kwiqela leemviwo.

Iifomula ezidweliswe zijoliswe njengeesampula zomsebenzi we-DATE. Ifom e:

• Umgca wesi-5 ungene ngosuku lokuqala lwenyanga ekhoyo;
• Umgca 6 uguqula umtya wesicatshulwa (iseli A5) kumhla;
• Umgca 7 ubonisa usuku lweveki ngomhla wokunika;
• Umqolo we-8 ubala iintsuku phakathi kwemihla yangoku kunye yangaphambili;
• Umgca 9 uguqula inombolo ye-Julian Day (iseli A9) ukuya kumhla wangoku;
• Umgca 10 uguqula umhla okhoyo (i-cell A10) kwiNombolo yoLuku lweYulian.

Ingcaciso engezantsi iquka amanyathelo asetyenziswa ukufaka umsebenzi we-DATE osefayilini B4. Isiphumo somsebenzi kweli phepha sibonisa umhla wokudibanisa owenziwe ngokudibanisa izinto zomhla ngamnye ezikhoyo kwiiseli A2 ukuya kwiC2.

Ukungena UMHLA Umsebenzi

Izinketho zokungena emsebenzini kunye neengxabano zayo kwiphepha lokusebenzela ziquka:

1) Ukuthayipha ngokufanelekileyo umsebenzi opheleleyo - khumbula nje ukuba umyalelo kufuneka ube yyyy, mm, dd njenga:

= UMHLA (2016,01,16) okanye,

= UMHLA (A2, B2, C2) xa usebenzisa iiferensi zeeseli

2) Ukusebenzisa ibhokisi ephakamisa ukuzenzekelayo ukufaka umsebenzi kunye neengxoxo zayo

Iipredishithi zeGoogle ayisebenzisi ibhokisi yencoko yababini yokufaka iingxabano zomsebenzi njengoko zifumaneka kwi-Excel. Endaweni yoko, inebhokisi ephakanyiswa yi- auto ephakamisa njengoko igama lomsebenzi lifakwe kwiseli.

Abahluli beComma

Xa usebenzisa enye indlela yokufaka umsebenzi, phawula ukuba ii-commas ( , ) zisetyenziselwa ukwahlula iziphakamiso zomsebenzi ngaphakathi kubakaki obanzi.

Amanyathelo angezantsi ajonga indlela yokufaka umsebenzi we-DATE osefesiteleni B4 kumfanekiso ongentla usebenzisa ibhokisi ephakamisa amehlo .

1. Cofa kwi-cell D4 ukwenzela ukuba yenze iseli esebenzayo - yiyo apho iziphumo zomsebenzi we-DATE ziya kuboniswa
2. Thayipha uphawu olulinganayo (=) olulandelwe igama lomhla wokusebenza
3. Njengoko uthayipha, ibhokisi ye -auto-suggestion ibonakala ngamagama kunye ne-syntax yemisebenzi eqala ngeleta D
4. Xa umhla ka- DATE ubonakala kwibhokisi, nqakraza kwigama kunye ne-pointer ye mouse ukuze ufake igama lomsebenzi kwaye uvule ibhoksi ejikelezayo kwi-cell D4
5. Cofa kwiseli A2 kwiphepha lokusebenzela ukuze ufake le ferensi yeseli njengengxabano yonyaka
6. Emva kwereferensi yeseli, thayipha i-comma ( , ) ukuba usebenze njengomhluli phakathi kweengxoxo
7. Cofa kwifowuni B2 ukungena kule ferensi yeseli njengengxabano yenyanga
8. Emva kwereferensi yeseli, thayipha enye i-comma
9. Cofa kwiseli C2 ukungena kule ferensi yesalathisi njengengxabano yosuku
10. Cinezela ukhiye wokungena kwibhodibhodi ukungena kwibhokisi yokuvala " ) kwaye ugcwalise umsebenzi
11. Umhla kufuneka uvele kwiseli B1 kwifomathi 11/15/2015
12. Xa ucofa kwiseli B1 umsebenzi opheleleyo = UMHLA (A2, B2, C2) uvela kwibha yefomula ngaphezu kwephepha lokusebenzela

Qaphela : ukuba isiphumo kwi-cell B4 ayilunganga emva kokungena emsebenzini, kungenzeka ukuba iseli ifomathiwe ngendlela engafanelekanga. Ngezantsi zidweliswe amanyathelo okutshintsha ifomathi yosuku.

Ukutshintsha Umhla wohlobo

Ukutshintsha kwifomati yamaphepha kwi-Google Spreadsheets

1. Gqamisa iiseli kwiphepha lokusebenzela eliqukethe okanye eliza kubandakanya imihla
2. Cofa kwiFomathi> Inombolo> Usuku kumamenyu ukutshintsha ifomathi yefomathi kwifomati yosuku esetyenziselwa izicwangciso zengingqi zangoku - jonga ngezantsi ukutshintsha izicwangciso zengingqi.

Utshintsho lweziThili zoMmandla

Njengemisebenzi eminingi ye-Intanethi, i-Google Spreadsheets ayifani nefomathi yohlobo lwama- American - eyaziwayo njenge- middle-endian-ye-MM / DD / YYYY.

Ukuba indawo yakho isebenzisa ifomathi yamaphepha ahlukeneyo - njenge- big-endian (YYYY / MM / DD) okanye encinci-edidi (DD / MM / YYYY) i-Google Spreadsheets ingalungiswa ukuze ibonise umhla ngendlela echanekileyo ngokulungisa izicwangciso zendawo .

Ukutshintsha izilungiselelo zesithili:

1. Chofoza ifayile ukuvula imenyu yefayile;
2. Cofa kwiSetreadsheet izicwangciso ... ukuvula ibhokisi yencoko yoqwalaselo;
3. Ngaphantsi kwendawo kwibhokisi yencoko, nqakraza kwibhokisi - ixabiso elingagqibekanga laseUnited States - ukubona uluhlu lwezilungiselelo zelizwe ezikhoyo;
4. Cofa kwilizwe lakho elikhethiweyo ukwenza ukhetho olukhoyo;
5. Cofa Gcina izicwangciso phantsi kwebhokisi yencoko yababini ukuyivala kwaye ubuyele kwiphepha lokusebenzela;
6. Imihla emitsha efakwe kwiphepha lokusebenzela kufuneka lilandele ifom yelizwe elikhethiweyo-iintsuku ezikhoyo zingadinga ukufomatha kwakhona ukuba utshintsho luqalise ukusebenza.

Iimpawu zeNombolo ezingekho phantsi kunye nee-Excel Dates

Ngokungagqibekanga, iMicrosoft Excel ye-Windows isebenzisa inkqubo yosuku eqala ngawo ngonyaka we-1900. Ukufaka inombolo ye-serial ye-0 ubuyisela umhla: Januwari 0, 1900. Ukongeza, umsebenzi we-Excel ka-DATE awuyi kubonisa imihla ngaphambi kwe-1900.

I-Google Spreadsheets isebenzisa umhla wamaDisemba ka-30, 1899 ngenombolo ye-serial ye-zero, kodwa ngokungafani ne-Excel, i-Google Spreadsheets ibonisa imihla phambi kwalo ngokusebenzisa iinombolo ezingenayo inombolo yenombolo.

Umzekelo, umhla kaJanuwari 1, 1800 kwiziphumo ze-serial -36522 kwi-Google Spreadsheets kwaye uvumela ukusetyenziswa kwazo kumafomula, njengokukhupha iJanuwari 1, 1850 -Januwari 1, 1800 ekhokelela kwixabiso le-18, 262 inani leentsuku phakathi kwemihla emibini.

Xa umhla ofanayo ungena kwi-Excel, ngakolunye uhlangothi, le nkqubo iguqula ngokuzenzekelayo umhla wokuthumela idatha kwaye ubuyisela i-#VALUE! Ixabiso lephutha xa umhla usetyenziswa kwifom.

Imihla Yosuku lweJulian

Inombolo Yosuku lweJulian, njengoko isetyenziswe ngamanqanaba karhulumente kunye neminye imibutho, ngamanani abamele unyaka nonyaka. Ubungakanani bala manani buhluka ngoxhomekeke kumaphi amadijithi asetshenziselwa ukumela umlinganiselo wonyaka kunye nomhla wenani.

Umzekelo, kumfanekiso ongentla, umhla we-Julian Day kwi-cell A9 - 2016007 - iindidi ezisixhenxe ezide kunye neenombolo zokuqala ezine zenani zimela umnyaka kwaye zintathu zokugqibela ngosuku lomnyaka. Njengoko kuboniswe kwiseli ye-B9, le nombolo ibonisa umhla wesixhenxe wonyaka we-2016 okanye ngoJanuwari 7, 2016.

Ngokufanayo, inani le- 2010345 limele umhla wama-345 wonyaka ka-2010 okanye ngoDisemba 11, 2010.