TIME

Formulas / TIME
Create a time with hours, minutes, and seconds.

=TIME(hour, minute, second)

Examples

TIME(3,0,0)
The TIME function is used to calculate the amount of time given certain parameters.This will return 3 hours.
TIME(0,0,3)
The TIME function can also be used to calculate the amount of minutes and seconds. Similarly, this example will return 3 seconds.
TIME(8,30,0)
The TIME function can be used to calculate decimal numbers as well. This example will return 8.5 hours. This can be useful for calculations involving fractions of an hour.
TIME(0,120,0)
The TIME function can also be used to convert minutes and seconds into hours. This example will return 2 hours.

The TIME function returns a decimal number for a particular time, and requires its arguments to be specified.

The TIME function in Sourcetable returns a decimal number representing a time in Sourcetable, between 0 and 23:59:59, up to one day.
The TIME function behaves like a 24-hour clock.

What does the TIME function do?

The TIME function returns the decimal number for a given time.

What are the arguments for the TIME function?

The arguments for the TIME function are required and include hour, minute, and second.

What type of number does the TIME function return?

The TIME function returns a decimal number.

What is the range of numbers that the TIME function returns?

The decimal number returned by TIME ranges from 0 to 0.99988426.

What times does the TIME function represent?

The TIME function returns a decimal number representing the times from 0:00:00 to 23:59:59.

Drop CSV