Yongeza umhla wangoku kunye nexesha kunye nomsebenzi we-Excel we-MANOW
Omnye wemisebenzi yamandulo eyaziwa kakhulu yi-Excel yinto esemthethweni, kwaye ingasetyenziselwa ukufaka ngokukhawuleza umhla okanye ixesha elikhoyo kwiphepha lokusebenzela.
Inokuthi ifakwe kwiintlobo zexesha kunye nexesha lokufumana iifomula zezinto ezifana nalezi:
- ukufumana imihla eninzi kangangeentsuku ezidlulileyo umhla okhoyo
- ukufumana inani leentsuku ekupheleni kwenyanga ekhoyo
- kubuya umzuzu wangoku
MANJE Umsebenzi we-Syntax kunye neeArguments
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakaki, abahluli be-comma kunye neengxabano .
I-syntax yalo MSEBENZI yile:
= MANJE ()
Qaphela: Umsebenzi we-MAN manje awunazo iingxabano-idatha ngokuqhelekileyo efakwe ngaphakathi kwabazali bomsebenzi.
Ukufaka umsebenzi okhoyo ngoku
Njengemisebenzi emininzi ye-Excel, umsebenzi we-MANOW ungangeniswa kwiphepha lokusebenzela usebenzisa ibhokisi yencoko yencoko yomsebenzi, kodwa ekubeni kungenanto i-arguments, umsebenzi ungangeniswa kwisisele esisebenzayo ngokuthayipha = Ngoku () kwaye ucinezela ukhiye wokungena kwikhibhodi . Isiphumo sibonisa umhla kunye nexesha langoku.
Ukutshintsha ulwazi oluboniswe, hlengisa ifomathi yefomathi ukubonisa nje umhla okanye ixesha usebenzisa iTebhu ithebhu kwibar menu.
Izinqamlezo zeeNqakrazo zokuFometha umhla kunye nexesha
Ukufometha ngokukhawuleza umsebenzi okhuphayo MSEBENZI, sebenzisa iifomaththi ezilandelayo zekhibhodi:
Umhla (ifomathi yenyanga yenyanga)
Ctrl + Shift + #Ixesha (iyure: umzuzu: ifomathi yesibini kunye ne-AM / PM - njengama-10:33:00 AM)
Ctrl + Shift + @Inani leNombolo / Umhla
Isizathu sokuba umsebenzi okwangoku ungathathi ngxabano kuba umsebenzi ufumana idatha yayo ngokufunda i-clock system clock.
Iifayile ze-Excel zigcina umhla njengenani elimele inani leentsuku ezipheleleyo ukususela phakathi kobusuku ngoJanuwari 1, 1900 kunye nenani leeyure, imizuzu kunye nemizuzwana yosuku olukhoyo. Le nombolo ibizwa ngokuba yinombolo yecala okanye umva we-serial.
ImiSebenzi eHlangeneyo
Ekubeni inombolo yecala iyanda ngokuphindaphindiweyo kwisibini nganye idlulayo, ukungena kumhla wangoku okanye ixesha kunye NOMSEBENZI okwangoku kuthetha ukuba iziphumo zomsebenzi ziguquka rhoqo.
Umsebenzi we-MAN manje ilungu leqela le-Excel yezinto ezinokuzenzekelayo , eziphinde zihlaziywe okanye zihlaziye rhoqo xa iphepha lokusebenzela apho lifumaneka khona.
Ngokomzekelo, amaxwebhu okusebenzela aphinde abuyele ngokuvakalayo xa ivuliwe okanye xa kwenzeka iziganeko ezithile-ezifana nokungena okanye ukutshintsha kwedatha kwiphepha lokusebenzela-ngoko usuku okanye ixesha litshintsha ngaphandle kokuba ukulungiswa ngokuzenzekelayo kuphelile.
Ukuphoqelelwa kweWebhu yokuSebenza / UkuQiniswa kweeNcwadi
Ukunyanzela umsebenzi ukuhlaziya nanini na, cinezela ezi zilandelayo zitshixo kwikhibhodi:
- Shift + F9 ukuhlaziya kwakhona iphepha lokusebenzela elikhoyo okanye langoku;
- F9 ukuhlaziya zonke iincwadi zokusebenzela ezivulekileyo.
Ukugcina iixesha kunye nexesha elimisiweyo
Ukuba nomhla kunye nexesha ngokutshintshayo akusiyo yonke into enqwenelekayo, ingakumbi xa isetyenzisiweyo kumanani omhla okanye ukuba ufuna usuku okanye ixesha lokubamba isitampu kwiphepha lokusebenzela.
Okukhethwa kukho ukungena kumhla okanye ixesha ukuze bangatshintshi kuquka ukuvala ukulungelelaniswa okuzenzekelayo, ukuthayipha imihla kunye namaxesha ngesandla, okanye ungene kuzo usebenzisa izicutshulwa zekhibhodi ezilandelayo:
- Umhla onqumlayo ulawulo + ; (semicolon)
- Ixesha elifutshane liLawula + Shift + : (i-colon)