convert time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some data that is in Number, Long Integer format. The data represents
seconds. I would like to convert to hh:mm:ss. Any suggestions?
 
Gear Gracie:

The hour portion would be:

[Some Data] \ 3600

The minutes:

[Some Data] \ 60 Mod 60

The seconds:

[Some Data] Mod 60

Tom Ellison
 
You can divide the number of seconds by 86400 (24 hrs per day * 60 minutes
per hour * 60 seconds per minute) to get an actual date/time value.

I would question why you want to display a duration of time as a point in
time.
 

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

Hundredths of Seconds Since Midnight 1
Storing time as integers 4
Convert Seconds 2
Time Data Conversion 3
convert dd:hh:mm:ss to seconds 5
conversion of seconds to other formats in MSAccess 3
Time calculation 1
Data Mismatch with join 2

Back
Top