Convert Seconds to hours/minutes BUT..

[GDCMike]

Hi,

I have an access database that extracts data from a call centre server. This stores the times in seconds, and I want to display HH:MM:SS HOWEVER.. when I do this the way i know how (Seconds/86400 formatted as long time) it works IF the number of hours is less than 24:00:00. If it is greater than this it rolls over back to 00:00:01.

For example - logged on time may be 50:01:10 but my report will display it as 02:01:10

Does anyone know how to do this?

Thanks,

GDCMike

 

[MichaelRed]

the ubiquitous {F1} (aka HELP) incluides the necessary information under format. Hint read the section on HOURS carefully.




MichaelRed
mlred@verizon.net

 

[GDCMike]

Thanks for this - I must be being extremely thick - but the only thing I can see about hours format in the help file is this:

h Hour in one or two digits, as needed (0 to 23).
hh Hour in two digits (00 to 23).
n Minute in one or two digits, as needed (0 to 59).
nn Minute in two digits (00 to 59).
s Second in one or two digits, as needed (0 to 59).
ss Second in two digits (00 to 59).

Can you point me to the right bit of the file please?

Thanks in advance

GDCMike