In this Article
This tutorial demonstrates how to use the Excel TIME Function in Excel to calculate a time.
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:
(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.
The TIME Function is used to create times by entering a hour, minute, and second:
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 – Fraction of Day
TIME values are stored as a decimal value in Excel:
TIME in Google Sheets
The TIME Function works exactly the same in Google Sheets as in Excel:
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 Examples in VBA
You can also use the TIME function in VBA. Type:
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