Open main menu

Returns the fractional portion of a double-precision decimal DateTime value, corresponding to the specified time.

The time is specified by a string expression "hh:mm:ss tt", where hh is the hours in the 12-hour AM/PM format, mm is the minutes, ss is the seconds, and tt is the AM/PM designator.

The integer portion of the DateTime value indicates the number of days that have elapsed since January 1st, 1900, and the fractional portion of the DateTime value indicates the fraction of the day that has passed since midnight.

Usage

StringToTime("hh:mm:ss tt")

Where: hh - hours in the 12-hour AM/PM format

mm - minutes

ss - seconds

tt - AM/PM designator

Notes

Described usage and examples are for the default US regional time format. Time format is controlled by the Regional Options settings that can be accessed from the Control Panel of the Windows XP operating system.

Example

StringToTime ("08:00:00 AM")  will return a value of 0.33333333 

StringToTime ("04:48:00 PM")  will return a value of 0.70000000