Navigation:  Formula Reference > Spreadsheet Formula Functions >

TIME

Previous pageReturn to chapter overviewNext page

 

This function returns the TimeSpan object for a specified time.

Syntax

TIME(hour,minutes,seconds)

Arguments

This function has these arguments:

Argument

Description

hour

Hour as a number from 0 to 23.

minutes

Minutes as a number from 0 to 59.

seconds

Seconds as a number from 0 to 59.

Data Types

Accepts numeric data for all arguments. Returns a TimeSpan object.

Examples

TIME(A1,B1,C1)

TIME(R1C1,R1C2,R1C3)

TIME(12,0,0) gives the result 12:00:00

TIME(16,48,10) gives the result 16:48:10

 

See Also

DAY

HOUR

MINUTE

NOW

TODAY