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

How to use Hour, Minute, and Second Function in Excel

The Hour, Minutе, and Second functions іn Microsoft Excel calculate the hour, minute, and second for time. In this tutorial, we will explaіn how to use these functions.

• Hour function returns the number from 0-23. The formula for the Hour Function is Hour(serial_number).
• The Minute function returns the minute, a number ranging from 0 to 59. The formula for the Minute function is Minute(serial_number).
• The Second function in excel returns a number ranging from 0 to 59. The formula for the Second function is Second(serial_number).

The syntax for Hour, Minute, and Second function

Hour

Serial_number: The time that includes the hour you want to find.

Minute

Serial_number: The time that includes the minute you want to find.

Second

Serial_number: The time that includes the Second you want to find.

How to use the Hour Function in Excel

In this article, we have a table displaying time, but we want to find the hour.

Click the cell where you want the result to be.

Type the function =Hour, then bracket.

We are going to enter the serial_number, enter A2:A5, then close the bracket.

Press Enter you will see the result.

The other option is to go to the Formula tab and click Date and Time in the Function Library group.

In the drop-down menu, select Hour, a Function Arguments dialog box will pop up.

In the Function Arguments dialog box, where you see Serial_ name, Type A2:A5 into the entry box.

Click, OK; you will see your result.

How to use the Minute Function in Excel

Click the cell where you want the result to be.

Type the function =Minute, then bracket.

We are going to enter the Serial_number, enter A2:A5, then close the bracket.

Press Enter you will see the result.

The other option is to go to the Formula tab and click Date and Time in the Function Library group.

In the drop-down menu, select Minute, a Function Arguments dialog box will pop up.

In the Function Arguments dialog box, where you see Serial_ name, Type A2:A5 into the entry box.

Click, OK; you will see your result.

How to use the Second Function in Excel

Click the cell where you want the result to be.

Type the function =Second then Bracket.

We are going to enter the Serial_number, enter A2:A5, then close the bracket.

Press Enter you will see the result.

The other option is to go to the Formula tab and click Date and Time in the Function Library group.

In the drop-down menu, select Second. A Function Arguments dialog box will pop up.

In the Function Arguments dialog box, where you see Serial_ name, Type A2:A5 into the entry box.

Click, OK; you will see the result.

I hope this was helpful.

Now read: How to use the 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