Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

TIME

Description: Returns the serial number for a specified time, where the HOUR, MINUTES and SECONDS are separated by commas. For example, =TIME(16,48,10) returns 0.700115741, which is the serial number that is equivalent to 4:48:10 PM.

Syntax: TIME(Hour, Minute, Second)

Remarks:

Example:

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.