Displaying more than 24 hours format

[Ed1138]

Hi all,


I'm trouble on how can i get Access to display a value as hours:minutes:seconds in a query when is a 24 hours or greater value, for example i have the value 1.00826388888889 if i were using Excel i would format it as [h]:mm:ss and it would output 24:11:54.

This image shows what i need, hope anyone can help on this one.
Attachment 19413

[June7]

Access formatting won't do this. Have to use an expression to convert the hours sum number into a string value. See post 9 in https://www.accessforums.net/access/...ime-38266.html

[Ed1138]

It seems that you are right June7, so far this is the only solution i have found, thanks.