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

By | April 22, 2019

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

Syntax of TIME function in Excel

Time-Function-in-Excel-How-to-use-Time-function-ExcelBlackBook.com

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)