Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
EndTime\3600 & ":" & Format((EndTime\60) Mod 60,"00") & ":" & Format(EndTime Mod 60,"00")
{/code]
If you try to convert the field straight to a time format using the Format() function, Access thinks your number of seconds is a number of days, and so gives the wrong result.
Hope this helps.
[pc2] [URL unfurl="true"]http://www22.brinkster.com/accessory/[/URL]