MKTIME(hours, mins)

 

Time Function Returns a Numeric Value or a Time Value
Converts hh:mm components into milliseconds. Returns a time value or the number of milliseconds depending on whether the field is formatted as a Time field or a Numeric field. Milliseconds are calculated using the following formula: (Hours x 3,600,000) + (Minutes x 60,000). Any value exceeding 23 hours 59 minutes will be returned as 11:59 PM if formatted as a Time field or as 86,340,000 milliseconds (i.e., 23 hours 59 minutes) if formatted as a Numeric field. Any value less than zero will be returned as 12:00 AM if formatted as a Time field or as 0 if formatted as a Numeric field. Time fields are formatted using the hh:mm AM format.

Examples:

MKTIME(5, 15)

Returns 5:15 AM if formatted as a Time field.

Returns 18,900,000 (without the commas) if formatted as a Numeric field.

MKTIME(29,10)

Returns 11:59 PM if formatted as a Time field.

Returns 86,340,000 (without the commas) if formatted as a Numeric field.

Other Resources

• Expression Examples
• Filtering Records
• Knowledge Base Article R11493 - All About Expressions
• Knowledge Base Article R11515 - Filter Expression Examples
• Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
• Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)