What time today will all these bugs be done?

=if(roundup(HOUR(GoogleClock())+1+G1)>24; "Another Day";if(roundup(HOUR(GoogleClock())+1+G1)>12; concatenate(roundup(HOUR(GoogleClock())+1+G1)-12;"pm"); concatenate(roundup(HOUR(GoogleClock())+1+G1);"am")))

G1
=sum(D:D)

D column contains the Estimated Time Remaining for each bug