How to Use Format to convert time in seconds to "XX:XX"

[KKUB]

I have converted time in seconds to a 24 hour clock format.
I tried to use the format constant to change the format to "XX:XX"

StrTotaltime: Format([HRS] & [Min],"nn:nn")
When I used the above the output displays 00:00 and doen't include the values from [HRS] and [MIN]. Where have I gone wrong?

 

[lupins46]

format(hrs,"00") & ":" & format(min,"00")

 

[KKUB]

Lupins46
That worked great. Thanks a Million

KKuB