Mental block: HH:MM:SS To Seconds please

Having a mare of a morning....

completely forgot how to turn HHMMSS into seconds e.g.

02:00:00 = 7200


cheers

just use the timer function, returns no elapsed seconds since midnight

well i know this works.. although it is still early here so my brain is not functioning too well right now.. there is probably a better way

VB Code:

Hour(TimeValue("02:00:00")) * 60 * 60) + (Minute(TimeValue("02:00:00")) * 60) + Second(TimeValue("02:00:00")