Microsoft® Excel® 2010 Formulas & Functions Inside Out

TIME()

Syntax. TIME(hour,minute,second)

Description. This function returns the serial number for a time indicated by the arguments hour, minute, and second.

Arguments

• hour (required). A number from 0 through 32,767 indicating the hour. Each value greater than 23 is divided by 24, and the remainder is the hour value. For example, TIME(28,0,0) corresponds to TIME(4,0,0), which is 4:00 or 4/24 or 0.16667.

• minute (required). A number from 0 through 32,767 indicating the minute. Each value greater than 59 is divided by 24*60 and converted into hours and minutes. For example, TIME(0,150,0) corresponds to TIME(2,30,0), which is 2:30 or 0.1041667.

• second (required). A number from 0 through 32,767 indicating the second. Each value greater than 59 is divided ...