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.
 
Back
Top