Reformat

[carl]

The Duration field is the difference between NewTime.

Is it possible to convert the Duration value to the one shown in NewFormat ?

NewID NewTime Duration NewFormat
1 9:31:16
2 9:31:37 0.00024306 0:00:21
3 9:31:41 4.63E-05 0:00:04
4 9:31:50 0.00010417 0:00:09

Thank you in advance

 

[KARL DEWEY]

Set the format to Format([YourField],"h:nn:ss") where ever you are
displaying it - query, form, or report.