From: Risse on

"Martin Prunty" <MartinPrunty(a)discussions.microsoft.com> kirjoitti
viestiss´┐Ż:EFD22292-F041-4C2B-AC6B-DCB6CAC73B1F(a)microsoft.com...
>I have an application that uses a stopwatch to capture time on various
> events. The stopwatch time is stored as a text file, which I would like
> to
> convert to a time format. The text value is "00:00:00:00" which needs to
> be
> converted to "dd:hh:nn:ss." I've tried just about every method I can find
> with no luck thus far. There are a number of posts on this topic and
> I've
> tried using "CDate," "DateSerial," "TimeSerial" and others, but each
> returns
> compile errors when I attempt to run a query to do the conversion.
>
> Any suggestions will be greatly appreciated. Thanks
>
> Marty
>