aduration = Int(ms / 1000)
bduration = aduration Mod 60 'calculates secs
cduration = (aduration - bduration) / 60 'calculates mins
Duration = cduration & ":" & bduration


This code uses the Mod function to convert seconds to Minutes and seconds. However, I need all of this in just on line for what duration =.... can this be condensed?