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.

Saacadda, Daqiiqada, iyo Shaqada Labaad ee Microsoft Excel

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) .



About the author

Waxaan ahay injineer software iyo khabiir Windows 10 ah. Waxaan leeyahay waayo-aragnimo ka badan laba sano oo ku saabsan la shaqaynta casriga ah, windows 10, iyo Microsoft Edge. Diiradayda ugu weyn waa ka dhigista aaladahaagu kuwo si ka wanaagsan oo degdeg ah u shaqeeya. Waxaan ka shaqeeyay mashaariic kala duwan shirkado ay ka mid yihiin Verizon, Imac, HP, Comcast, iyo kuwo kale oo badan. Sidoo kale waxaan ahay macalin shahaado ka haysta tababarka daruuraha Microsoft Azure.



Related posts