converting time (format) to number

B

Boge

Hi
I am using ms access and I would like to make querry that will convert
certain time (ex. 00:25:05) to number of seconds
can anyone help since I can not find the solution
Thanks
 
D

Douglas J. Steele

Time is stored as a fraction of a day. Multiply the time value by the number
of seconds in a day (86400).

?#00:25:05#*86400
1505
 
Top