Hi I need know how to subtract times: [TimeVar]=Time1-Time2 10:03:00=18:03:00-8:00:00 Thanks

Depands on the language. There are tons of free TIME libraries for c/c++ ===================================== If at first you don't succeed, you're about average. M2

Multiply them out into seconds, subtract them then divide them back. 18:03:00 = (18 * 60 + 3) * 60 + 0 = 64980 8:00:00 = (8 * 60 + 0) * 60 + 0 = 28800 64980 - 28800 = 36100 37800 / 3600 = 10 r 180 = 10 hours 180 / 60 = 3 r 0 = 3 minutes, 0 seconds

Hi I am talking about Access VBA. Is there any function that can sabtract between two time variants and returns time result.

Don't know about access VBA but it is very similar to VBScript. This is how I would do it in VBScript. You can stick the following into a .wsf file and run it from the command line. <job> <script language="vbscript"> dim t1, t2, dayfrac, h, m, s t1 = #18:03:00# t2 = #8:00:00# dayfrac = t1 - t2 s = clng(dayfrac * 86400) h = s \ 3600 s = s mod 3600 m = s \ 60 s = s mod 60 ' Do this instead of format date in case we get 24:00:00. WScript.echo right(cstr(h+100),2) & ":" & right(cstr(m+100),2) & ":" & right(cstr(s+100),2) </script> </job>