Nice correction, Dayylonglegs. Thank you.

--
Regards

Roger Govier


"daddylonglegs"
wrote in
message
news:daddylonglegs.23fmlm_1140278101.1538@excelfor um-nospam.com...

Hello Richard,

try this amendment to Roger's formula

=A1-CEILING(SUM(Hlist!D:D)/8,1)&" Days "&MOD(8-SUM(Hlist!D:D),8)&"
hours left"


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=513975