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)