How enter elapsed time. eg 3 mins 27.99 seconds in access/xcell

G

Grizz

I want to enter an elpsed time into access eg 3mins 25.87 seconds. Have tried
custom format but keep schanging to date format
 
J

John W. Vinson

I want to enter an elpsed time into access eg 3mins 25.87 seconds. Have tried
custom format but keep schanging to date format
Click to expand...

A Date/Time field type is not going to work for you here: it's limited to a
granularity of one second, and doesn't handle fractions of a second. In
addition, Date/Time values work best to store specific points in time, not
durations.

I'd suggest using a Double Float number datatype to store elapsed seconds (and
fractions) - e.g. 385.87 seconds. You can display and enter this as minutes
and seconds by using one bound textbox and two unbound ones, for minutes and
seconds, with a bit of VBA code in their AfterUpdate events to fill in the
bound control, and some code in the form's Current event to translate the
duration into minutes and seconds:

Private Sub Form_Current()
Me!txtMin = Me!txtDuration \ 60
Me!txtSec = Me!txtDuration - 60*(Me!txtDuration \ 60)
End Sub
 
Top