Convert Single to Seconds

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database which is storing a numeric value (single data type). I
need to convert this value to seconds.

Example:
36.2
00:36.2

I appreciate the help in advance.
 
I have a database which is storing a numeric value (single data type). I
need to convert this value to seconds.

Example:
36.2
00:36.2

I appreciate the help in advance.
Click to expand...

An Access Date/Time value cannot display fractional seconds. Single
seconds are the best it can do.

To *display* minutes and seconds as a text string, try

Format([yourfield] \ 60, "00:") & Format([yourfield] - 60 *
([yourfield] \ 60), "00.0")


John W. Vinson[MVP]
 
Back
Top