TIME (PQL - xl)

This function returns the TimeSpan object for a specified time

  • Library: PQL \ Spreadsheet \ Date & Time
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

TIME(hour, minute, second)

Function Arguments

Name

Description

Type

Optional

hour

Hour as a number from 0 to 23

Number

minute

Minutes as a number from 0 to 59

Number

second

Seconds as a number from 0 to 59

Number

Comments

This function is the same as the Microsoft Excel 'TIME' function - using the same inputs, logic and outputs.