Recent content by pprakken

Hi, Well yes I figured that out that minutes are nn. But still in excel you have the format: [h]:mm:ss This will give 46:12:34 as result for example 46 hours, 12 minutes and 34 seconds. In access you can enter the format: [h]:nn:ss but it does not work it would show as result of the same...

Hello, I am trying to show the hhhh:mm:ss format in access, however it remains withint the 24 hours limit. when I try [h]:mm:ss. I read here that you need a conversion formula for this. Can someone tell me what this is? Thanks, Peter