Post by lindagHow can I convert Hundredths of Seconds Since Midnight to a time
hh:mm:ss.
DateAdd("s", 100*[hundredths], #12/30/1899#)
or
TimeValue(0, 0, 100*[hundredths])
--
John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com