Sida loo isticmaalo Saacadda, Daqiiqada, iyo Shaqada Labaad ee Excel
Saacadaha , Daqiiqada(Minute) , iyo Hawlaha Labaad ee Microsoft Excel waxay xisaabiyaan saacadda, daqiiqo, iyo labaad ee waqtiga . (Hour)Tababarkan, waxaan ku sharixi doonaa sida loo isticmaalo howlahan.
- Shaqada saacadu(Hour ) waxay soo celisaa lambarka 0-23. Qaabka Shaqada Saacaddu(Hour) waa Saacad (serial_number)(Hour(serial_number)) .
- Hawsha daqiqadu(Minute) waxa ay soo celisaa daqiiqada, tiro u dhaxaysa 0 ilaa 59. Habka daqiqadu waa Minute (serial_number)(Minute(serial_number)) .
- Shaqada labaad(Second) ee excel waxay soo celinaysaa tiro u dhaxaysa 0 ilaa 59. Qaabka shaqada labaad(Second) waa labaad(serial_number)(Second(serial_number)) .
Isku dhafka Saacadda(Hour) , Daqiiqada(Minute) , iyo Shaqada Labaad(Second)
Saacada(Hour)
Serial_number : Waqtiga ay ku jirto saacadda aad rabto inaad hesho.
Daqiqo(Minute)
Serial_number : Waqtiga ay ku jirto daqiiqadda aad rabto inaad hesho.
Labaad(Second)
Serial_number : Waqtiga uu ku jiro Labaad ee(Second) aad rabto inaad hesho.
Sida loo isticmaalo Shaqada Saacadda(Hour Function) ee Excel
Maqaalkan, waxaan ku haynaa miis muujinaya waqtiga, laakiin waxaan rabnaa inaan helno saacadda.
Guji(Click) unugga meesha aad rabto in natiijadu noqoto.
Ku qor shaqada =Hour , ka dibna ku dheji.
Waxaan gali doonaa serial_number , gali A2: A5 , ka dibna xidh xidhidhka.
Riix Gelida(Enter) waxaad arki doontaa natiijada.
Doorashada kale waa in aad tagto tab Formula oo aad gujiso (Formula)Taariikhda iyo Waqtiga(Date and Time) kooxda Maktabadda Shaqada(Function Library group) .
Liiska hoos-u-hoosaadka, dooro Saacadda(Hour) , sanduuqa wada-hadalka doodaha Shaqada ayaa soo bixi doona.(Function Arguments)
In sanduuqa wada hadalka doodaha Function(Function Arguments) , halkaas oo aad ku aragto Serial_ name , Nooca A2: A5 galay sanduuqa gelitaanka.
Guji, OK ; waxaad arki doontaa natiijadaada.
Sida loo isticmaalo Function Minute(Minute Function) in Excel
Guji(Click) unugga meesha aad rabto in natiijadu noqoto.
Ku qor shaqada =Minute , ka dibna garabka.
Waxaan geli doonaa Serial_number , geli A2:A5 , ka dibna xidh xidhidhka.
Riix Gelida(Enter) waxaad arki doontaa natiijada.
Doorashada kale waa in aad tagto tab Formula oo aad gujiso Date and Time in the Function Library group.
Liiska hoos-u-hoosaadka ah, dooro Daqiiqado(Minute) , sanduuqa wada-hadalka Doodaha Shaqada ayaa soo bixi doona.(Function Arguments)
In sanduuqa wada hadalka doodaha Function(Function Arguments) , halkaas oo aad ku aragto Serial_ name , Nooca A2: A5 galay sanduuqa gelitaanka.
Guji , OK ; waxaad arki doontaa natiijadaada.
Sida loo(Excel) isticmaalo shaqada labaad ee Excel(Function)
Guji(Click) unugga meesha aad rabto in natiijadu noqoto.
Ku qor shaqada =Second kadibna Bracket.
Waxaan geli doonaa Serial_number , geli A2:A5 , ka dibna xidh xidhidhka.
Riix Gelida(Enter) waxaad arki doontaa natiijada.
Doorashada kale waa in aad tagto tab Formula oo aad gujiso Date and Time in the Function Library group.
Liiska hoos-u-dhaca, dooro Labaad(Second) . Sanduuqa wada hadalka doodaha Function(Function Arguments) ayaa soo bixi doona.
In sanduuqa wada hadalka doodaha Function(Function Arguments) , halkaas oo aad ku aragto Serial_ name , Nooca A2: A5 galay sanduuqa gelitaanka.
Guji, OK ; waxaad arki doontaa natiijada.
Waxaan rajeynayaa in tani ay waxtar lahayd.
Hadda akhri(Now read) : Sida loo isticmaalo shaqada DCOUNT iyo DCOUNTA ee Microsoft Excel(DCOUNT and DCOUNTA Function in Microsoft Excel) .
Related posts
Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel
Sida loo isticmaalo Rept Function gudaha Excel
Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel
Sida loo isticmaalo RANDBETWEEN Function gudaha Excel
Sida loo isticmaalo shaqada TYPE ee Excel
Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel
Sida looga soo saaro magacyada domain URL-yada Microsoft Excel
Sida loo abuuro Bracket tartanka gudaha Windows 11/10
Sida loo isticmaalo shaqada ISODD ee Excel
Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel
Adeegso Excel Mobile's cusub ee shaqada "Ka Geli Xogta Sawirka".
Sida loo isticmaalo shaqada IF ee Excel
Sida loo midoobo oo loo kala saaro unugyada Excel
Sida loo dayactiro buug-shaqeedka Excel ee xumaaday
Sida loo isticmaalo Find and FindB functional in Excel
Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel
Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah
2 siyaabood oo loo Isticmaalo Shaqada Transpose ee Excel
Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint
Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel