Is there a function that will return time of day in seconds? One can certainly obtain the time formatted hh:mm:ss and do some arithmetic on the individual parts but there's got to be a simpler way.
For Example:
Code:strTime = Format(Time, "hh:mm:ss") TimeNow = 60 * 60 * Left(strTime, 2) + 60 * Mid(strTime, 4, 2) + Right(strTime, 2)