Subtract dates > 24hrs and display as days:hours:minutes

[neelsfer]

I try and subtract the admission and discharge dates of patients at a hospital.
discharge = discharge date (end) / admit = admission date (start)
I use the following code and it works but the layout/format is not what i require.

PatientDays: Int([discharge]-[admit]) & Format([discharge]-[admit],""" days ""h"" hrs, ""n"" min""")

i get this result

2 days 10 hrs, 0 min

i would prefer it to be like this:

02:10:00

Any suggestions pls?

[Luuk]

You should try to understand how the function 'Format()' works.
(see: the manual)

next line might have the solution:

Int(discharge - admit) & Format([discharge] - [admit], """:""h"":""n"" """)

[neelsfer]

Thx Luuk it works 100%. I have been trying all sorts of variations.