|
Posted to microsoft.public.excel.misc
|
|
|
convert units
Many thanks!
"daddylonglegs" wrote:
Try this formula
=INT(ROUND(A8,0)/24)&" days, "&MOD(ROUND(A8,0),24)&" hours"
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=514541
|