First, format the output cell as Custom [H]:mm then enter this
formula:

=(A1/1440)

where A1 holds your 2000 minutes. This will return 33:20 (which is
2000/60 to get a decimal hours and then /24 to get a decimal days.
Formatting as above (bracketed 'H') forces Excel to return total hours
and not round it to days.

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=381961