This content has been marked as final. Show 3 replies
time#(num(floor(TIMEinMINUTES/60), '00') & ':' & num(TIMEinMINUTES-(floor(TIMEinMINUTES/60)*60), '00'), 'hh:mm')
Just thought about what if you have TIMEinMINUTES = 10000? May be you want more sophisticated solution which can produce you in formaxt: "x days y hours and z minutes". Depends on what you trying to do. Anyway, you get the idea.