Discussion:
Hundredths of Seconds Since Midnight
(too old to reply)
lindag
2012-05-31 19:44:46 UTC
Permalink
How can I convert Hundredths of Seconds Since Midnight to a time
hh:mm:ss.
John W. Vinson
2012-06-01 15:50:01 UTC
Permalink
Post by lindag
How 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
Loading...