Format problem

[MisterrMac]

I have a Query pivot table that is generating totals and grand totals of a number which is actually seconds. I would like to show these totals and grand totals in a time format: hh:mm:ss Is this possible?

Thanks

Loren

 

[mikey69]

Yes - you can format the output in the query grid. Right click on the field, choose properties and then choose the time format

 

[MisterrMac]

Already tried that. It outputs 12:00, irregardless of the number.

Thanks anyway.

 

[RickSpr]

You need to divide the seconds by 86400, the number of seconds in a day. The time format is expecting a date/time value, which is a floating point number containing the time expressed as a fraction of 1 day. Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein