DATETIME() for converting numbers to time

Version 5

    DATETIME() can be used to convert numeric calculations directly to (date)time:

     

    [industry time]DATETIME( [industry time] / 24 )  format: hh:nn
    3.003:00
    0.500:30
    1.2501:15

     

    See also  Re: Date "industry time".

     

    Online help  states that it can take number expressions, but would wish it also showed some examples of it:

     

    DATETIME(expression)

    Returns a datetime given a number, string, or date expression.

    Example

    DATETIME(“April 15, 2005 07:59:00”) = April 15, 2005 07:59:00