Time calculations

[benshsms]

Basic one really but struggling with it

I have 2 time fields and want to calculate the difference between the two (with the result being a time). Datediff doesnt work becuase they are time variable (its part of a larger calc so I dont want to convert the variate to a datetime). I've tried just doing

endtime - starttime

but the result appears somewhat strange (for example endtime of 20:00 - start time of 08:00 comes out as 43,200

Any help gratefully received

 

[Reebo99]

Use:

DateDiff("n",DateTime(currentDate,{starttime}),DateTime(currentDate,{endtime}))

Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.

 

[benshsms]

thanks
works a treat