Excel TIME() Function

Excel TIME() Function

The TIME() function in excel returns the serial number of a particular time.

Syntax

TIME(HOUR, MINUTE, SECOND)

Parameter

HOUR (required)- This parameter represents the hour for your time.

MINUTE (required)- This parameter represents the minute for your time.

SECOND (required)- This parameter represents the second for your time.

Category

Date & Time

Return

This function returns the serial number of a particular time.

Example 1

Objective: Merge different time components and return in recognize Excel time format

HOUR MINUTE SECOND Time Formula Text
17 37 39 5:37:39 PM =TIME(B205,C205,D205)
11 7 24 11:07:24 AM =TIME(B206,C206,D206)
12 30 45 12:30:45 PM =TIME(B207,C207,D207)
0 0 0 12:00:00 AM =TIME(B208,C208,D208)

Example 2

Objective: Add '49' seconds to the time given and return the result

HOUR MINUTE SECOND Time Formula Text
17 37 39 5:38:28 PM =TIME(B205,C205,D205+49)
11 7 24 11:08:13 AM =TIME(B206,C206,D206+49)
12 30 45 12:31:34 PM =TIME(B207,C207,D207+49)
0 0 0 12:00:49 AM =TIME(B208,C208,D208+49)



ADVERTISEMENT
ADVERTISEMENT