You mean the value is 3164? So a whole number of minutes? Because '52hrs 44min' isn't a number.
A text box with this:
=interval((3164/60)/24,'hh:mm')
Gives this result:
52:44
Your problem is not with the interval() and how people are telling you to do it. Your problem lies elsewhere. Perhaps the value isn't actually 3164, for instance. For that matter, it is IMPOSSIBLE to get result '12' with the expression Karl gave you, because the format will insert a colon. So maybe you got '00:12' or '12:00', but you didn't get '12'. Or if you DID get '12', you aren't using Karl's expression.
