Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting seconds to hours/minutes/seconds

Status
Not open for further replies.
Drepso

Drepso

Technical User
Jul 22, 2002
50
AU
Hi

I have a table which stores time intervals in seconds. I would like to format these to hh:mm:ss.

Can anyone help me with this?

Any help would be greatly appreciated. Thanks in Advance.

Cheers
 
Sort by date Sort by votes
Hi Drepso,

If the total is always less than 24 hours, you could convert it to a fraction of a day and use the built in format option ..

Code: 
Format([YourSeconds] / 86400, "hh:mm:ss")

Enjoy,
Tony
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Question
Converting from 32bit to 64 bit. After converting, database takes significantly longer to open 1
Replies
14
Views
1K
dhookom
dhookom
hermanlaksko
  • Question
Convert PDF file to text
Replies
6
Views
397
hermanlaksko
hermanlaksko
Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
702
Zyborg
Zyborg
Kennelbloke
  • Locked
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
1K
Kennelbloke
Kennelbloke
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
742
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top