Timeformat

[marcus]

Hi.

I have a litle problem. I have a starttime and a
finishtime and want to calculate the difference. My
problem is that I want to use hundreds of a second but
this timeformat dosent works (hh:nn,00) it works in Excel
but not in Acess, how to do?

Marcus

 

[John Vinson]

Hi.

I have a litle problem. I have a starttime and a
finishtime and want to calculate the difference. My
problem is that I want to use hundreds of a second but
this timeformat dosent works (hh:nn,00) it works in Excel
but not in Acess, how to do?

Access Date/Time values simply don't have any support for sub-second
resolution. I'd suggest storing the duration in a Double Float number
of seconds; you can use an expression like

[duration] \ 3600 & Format([duration] \ 60 MOD 60, ":00") &
Format([duration] - 60*([duration] \ 60), ":00.00")

to display as hh:nn:ss.ss.