TIME(H, M, S)

 

Description

This function returns the time value represented as a fraction of a day, starting at midnight.  H must be between 0 and 23, and M and S must be between 0 and 59.

 

Refer to DATE for more information on datetime values.

 

Parameters

 

H

Hour.

 

M

Minute.

 

S

Second.

 

Examples

 

TIME(12, 0, 0) = 0.5

Where 0.5 represents half of a day, which is noon.

 

TIME(8, 45, 46) = 0.36511574

 

HOUR(TIME(C1, D1, E1)) = 13

Where C1 = 13, D1 = 40, and E1 = 2.