convert time

G

Gracie

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?
 
T

Tom Ellison

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
 
D

Duane Hookom

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