MS Excel: Time Function

In Excel, the Time function returns the decimal number for a particular time.

The syntax for the Time function is:

Time( hour, minute, second )

hour is a number from 0 to 23, representing the hour.

minute is a number from 0 to 59, representing the minute.

second is a number from 0 to 59, representing the second.

Applies To:

Let's take a look at an example:

Based on the spreadsheet above, the function would return the following values:

=Time(A1, A2, A3) would return "3:30:37 AM"

=Time(12, 59, 17) would return "12:59:17 PM"

=Time(14, 2, 1) would return "2:02:01 PM"