Time,Hour,Minute,Second Function in Excel

 

Time Function

 

=TIME(A2,B2,C2)

 

	A	B	C	D
1	Hour	Minute	Second	Time
2	23	12	56	11:12 PM
3	11	6	12	11:06 AM
4	14	25	23	2:25 PM
5	10	4	55	10:04 AM

 

Hour Function

 

=HOUR(A2)

 

	A	B
1	Time	Hour
2	21:52:23	21
3	22:18:20	22
4	8:36:05	8
5	6:56:08	6
6	17:05:06	17

 

Minute Function

 

=MINUTE(A2)

 

	A	B
1	Time	Minute
2	21:52:23	52
3	22:18:20	18
4	8:36:05	36
5	6:56:08	56
6	17:05:06	5

 

Second Function

 

=SECOND(A2)

 

	A	B
1	Time	Second
2	21:52:23	23
3	22:18:20	20
4	8:36:05	5
5	6:56:08	8
6	17:05:06	6