How can I convert Hundredths of Seconds Since Midnight to a time hh:mm:ss.
J John W. Vinson Jun 1, 2012 #2 How can I convert Hundredths of Seconds Since Midnight to a time hh:mm:ss. Click to expand... 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
How can I convert Hundredths of Seconds Since Midnight to a time hh:mm:ss. Click to expand... 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
