Excel TIME Function

This tutorial demonstrates how to use the Excel TIME Function in Excel to calculate a time.

TIME Main Function

TIME Function Overview

The TIME Function Returns the time from a hour, minute, and second.

To use the TIME Excel Worksheet Function, Select cell and Type:

time formula syntax

(Notice how the formula input appear)

TIME Function syntax and Inputs:

hour – An hour between 0-23. Example: 13.

minute – A minute between 0-59. Example: 13.

second – An hour between 0-23. Example: 13.

TIME Examples

The TIME Function is used to create times by entering a hour, minute, and second:

Time

TIME – HOUR, MINUTE, SECOND Functions

Often the TIME Function is used along with HOUR, MINUTE, or SECOND Functions to calculate a time based on another time.

This example will return a time 8 hours after another time:

TIME Plus HRS

Time – Fraction of Day

TIME values are stored as a decimal value in Excel:

TIME Value

TIME in Google Sheets

The TIME Function works exactly the same in Google Sheets as in Excel:

TIME Google Sheet

Additional Notes

Simply enter numbers corresponding to the Hour, Minute, and Second of the time.

Minutes and seconds can be greater than 59 or less than 0.

=time(8,0,0) returns 8:00:00 AM.
From this starting point you can add or subtract minutes or seconds.

=time(8,-1,-1) returns 7:58:59 AM.

=time(8,61,61) returns 9:02:01 AM.

The result of the TIME Function may appear as a decimal number. Change the cell Number Formatting to TIME to display the time:
time formatting excel shortcut

TIME Examples in VBA

You can also use the TIME function in VBA. Type:
application.worksheetfunction.time(hour,minute,second)
For the function arguments (hour, etc.), you can either enter them directly into the function, or define variables to use instead.

Return to the List of all Functions in Excel