TimeToSec

TimeToSec()

Calculates the seconds since midnight

Syntax

      TimeToSec(<cTime>) --> nSeconds

Argument

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

Returns

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

Description

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.

Examples

      .  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")

Seealso

SECTOTIME()

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s