Collapse All Expand All

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

 

 

---

Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.