Tag Archives: Functions in Excel

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… Read More »