Timeformat

  • Thread starter Thread starter marcus
  • Start date Start date
M

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
 
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?
Click to expand...

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.
 
Back
Top