STOT( ) function

Converts a serial time – that is, a time expressed as a fractional portion of 24 hours, with 24 hours equaling 1 – to a time value. Abbreviation for “Serial to Time”.

Syntax

STOT(serial_time)

Parameters

serial_time

Numeric. The field, expression, or literal value to convert.

The serial_time parameter can accept a serial time or a serial datetime. Only the time portion of serial datetimes is considered. The date portion is ignored.

Output

Datetime. The time value is output using the current ACL time display format.

Remarks

The STOT( ) function allows you to convert serial times to regular times. ACL serial times represent a fractional portion of 24 hours, with 24 hours equaling 1. For example, the serial time equivalent of 1 hour is 1/24, or 0.04167. The serial time equivalent of 1 minute is 1/1440, or 0.0006945. Serial times can be prefaced with a ‘0’ (zero) and a decimal point, or just a decimal point.

Although 24 hours equals 1 for the purposes of calculating serial times, 1.000000 is not a valid serial time. Valid serial times are all decimal fractions less than 1 – for example: 0.75000 (06:00:00 PM). ACL treats the serial number 1.000000 as the serial datetime equivalent to 02 Jan 1900 12:00:00 AM. Because STOT( ) ignores the date portion of datetimes, STOT(1.000000) is equivalent to STOT(0.000000) and both are equivalent to the regular time 12:00:00 AM.

Serial time

Regular time equivalent

0.00

12:00:00 AM

0.0006945

12:01:00 AM

0.04167

01:00:00 AM

0.0423645

01:01:00 AM

0.042998

01:01:55 AM

0.25

06:00:00 AM

0.50

12:00:00 PM

0.75

06:00:00 PM

0.79167

07:00:00 PM

0.802431

07:15:30 PM

1.00

12:00:00 AM

Examples

Example Return value

STOT(0.25000)

06:00:00 AM

Assumes a current ACL time display format of hh:mm:ss PM

STOT(0.802431)

07:15:30 PM

Assumes a current ACL time display format of hh:mm:ss PM

STOT(Login_time)

The equivalent regular time for each serial time value in the Login_time field

Related reference
STOD( ) function
STODT( ) function


(C) 2015 ACL Services Ltd. All Rights Reserved.