How to format an amount of time > 24hr

You come up with some good ones Killer.
Try "0 hh:nn:ss"

This does, of course, mean that ALL times are shown including a day indicator.

You come up with some good ones Killer.
Try "0 hh:nn:ss"
This does, of course, mean that ALL times are shown including a day indicator.

Thanks, I'll give it a shot.

the formatting won't work if you used the datediff to get the difference as it returns an integer result. How to do it de[ends on the smallest unit of difference you want to report on. If, for example you want to show hors & minutes the following code works

the formatting won't work if you used the datediff to get the difference as it returns an integer result. How to do it de[ends on the smallest unit of difference you want to report on. If, for example you want to show hors & minutes the following code works

Dim Diffierence as long
Dim FormattedTime as string

Difference = datediff("n",Firstdate,SecondDate)
formattedtime = int(difference/60) & " Hrs " & difference mod 60 & " Min

if you want days, hours & minutes the code would be

formattedtime = int(diference/1440) & " Days " & int((difference mod 1440)/60) & " Hrs " & int((difference mod 1440) mod 60) & " Min"

This code will give you the time diffrenece in days, hrs & minutes for all dates

Thanks for that, Andrew. But I am simply subtracting two date/time fields. The result is a tiny number, see original post for a sample. I am happy with this result, as I often copy/paste the result set to Excel for graphing and so on, and apply the format [h]:mm:ss there, which gives me as many digits as I need for the hours.

I just prefer to have it formatted as an amount of time in Access too, but the hh:nn:ss I was using there is not quite right, and it doesn't recognise the one from Excel.