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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Create an S-Curve from Custom Field? 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Converting URLs in comments to Markdown-formatted links 2
Remove numbers from brackets 0
Autonumber field in Excel that behaves the same as Access 0
Real-Time Co-Authoring stops working 0
Need help removing extra TOC text from number lists used as TOC levels 0
Paste Link and Link Text From Browser to Word 0

Top