Convert Single to Seconds

R

Raymond Clarke

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.
 
J

John Vinson

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]
 
Top