counting minutes time formula

[asyamonique]

=IF(SUM(B18:AF18)>=0,"","-")&TEXT(ABS(SUM(B18:AF18)/1440),"h""hrs""  mm""min""")

Hello,
What would be the alteration if I wanted do the changes to show overall time more then 24hrs.?
If total minutes 1953min it will show 32hrs 33min
Thanks

 

[AlphaFrog]

Try this...

=IF(SUM(B18:AF18)>=0,"","-")&INT(SUM(B18:AF18)/60)&"hrs "&MINUTE(SUM(B18:AF18)/1440)&"min"

 

[asyamonique]

Thanks,
But it doesn't gives negatives!

 

[AlphaFrog]

=IF(SUM(B18:AF18)>=0,"","-")&INT(ABS(SUM(B18:AF18))/60)&"hrs "&MINUTE(ABS(SUM(B18:AF18))/1440)&"min"

 

[asyamonique]

Thank you