TIME Function in Excel, How to use TIME Function in Excel?

Function TIME accepts integer values representing hrs, mins and seconds and returns Excel time.

Syntax of TIME function in Excel

TIME(hour,minute,second)

Example:-

TIME(26,0,0) = 02:00:00

TIME(25,12,0) = 01:12:00

Hour Value

If hour value is greater than 23 then Excel calculates it by dividing it by 24 and returning the remainder

Example: –

TIME(25,12,0) returns a value of 01:12:00 which means 25%24==1

Minute = Minute if greater or less than 59 will add the following hour or previous hours.

Example: –

TIME(2,20,13) = 02:20:13
TIME(2,-2,13) = 02:18:13
TIME(3,62,13) = 03:02,13

All the decimals supplied in arguments will be converted to decimals.

DATE (2015, 13, 5) would return January 5, 2016 (13 = 12+1 Month i.e January)

If DATE(2015, -2, 5) would return October 5, 2015 (10 = 12-2 Month i.e OCtober)