Times Subtraction Whith Access

[bennyzamir]

Hi

I need to know how to subtract between two times variants and to get a
time result (With Access).
Like this:

VarTime=[time1]-[time2]
10:05:40=18:05:50-08:00:10

Thanks

 

[Douglas J. Steele]

Access really isn't intended to do things like that, but

?Format(#18:05:50# - #08:00:10#, "hh:nn:ss")
10:05:40