>I have a field that is the duration of a call in seconds. Does anyone have a calculation to convert this duration into hours and minutes?
>
>TIA
>
Kris,
One hour is 3600 seconds and one mintue is 60 seconds. So;
lnSeconds = YourTable.FieldName
lnHours = INT(lnSeconds/3600))
lnMinutes = INT(MOD(lnSeconds/3600)/60)