Calculates the seconds since midnight


      TimeToSec(<cTime>) --> nSeconds


<cTime> Designates a character string that contains the time in the format “HH:MM:SS:hh”. The default is the system time.


The returned value designates how many seconds have elapsed between midnight and <cTime>. Hundredths of seconds are contained as a decimal value.


When computing time periods, or when adding times, it is simpler to deal with seconds since midnight instead of time designations. These calculations are simplified significantly. The SECTOTIME() function converts the result into a time designation again. Starting from back to front, you can omit the hundredths, seconds, and minutes from the time string that is passed as a parameter. These values are then assumed to be “00”.

If you do not specify a parameter, the function uses the current time on the system clock.


      .  A simple conversion:

      ? TimeToSec("12:44:33:22")                 // Result:  45873.22

      .  The period between two times is calculated. The result is
         displayed in seconds:

      cBegin      :=  "12:55:44:33"
      cEnd        :=  "14:56:12:22"

      ? TimeToSec(cEnd) - TIMETOSEC(cBegin)      // Period in seconds

      .  Possible formats:

      ? TimeToSec("12")
      ? TimeToSec("12:44)
      ? TimeToSec("12:44:33)
      ? TimeToSec("12:44:33:22")



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.