Mental block: HH:MM:SS To Seconds please

**crispin** · Jul 26th, 2002, 07:45 AM

Having a mare of a morning....

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

02:00:00 = 7200

cheers

**flipper296** · Jul 26th, 2002, 07:48 AM

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

**kleinma** · Jul 26th, 2002, 07:50 AM

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

Thread: Mental block: HH:MM:SS To Seconds please