MinutesToTime (Function)

Disclaimer

The MinutesToTime function converts a number of minutes from midnight to a 24-hour military time format (HHMM).

Syntax

MinutesToTime(Minutes)

Returns (Integer)

A numeric value containing the time in military format (for example, 1530 = 3:30pm).

Parameters

Name	Type	Description
Minutes	Numeric	Specifies the number of minutes since midnight

Example

Assigns to Value1 the 24-hour military time value of 0130 based on an input of 90 minutes.

Value1 = MinutesToTime(90);