Time s2Time

Returns a numerical value indicating the time in the HHmm format, corresponding to the specified time in the HHmmss format; the seconds are truncated.

The time is returned in the 24-hour HHmm format, where 1300 = 1:00 PM, and specified in the 24-hour HHmmss format, where 130000 = 1:00:00 PM.

Usage

Time_s2Time(HHmmss)

Where: HHmmss - a numerical expression specifying the time

Example

Time_s2Time(101520)  will return a value of 1015 

Time_s2Time(154548)  will return a value of 1545