=int(A1-now())&" "&if(days(A1,now())>1,"Days","Day")&" : "&hour(A1-now())&" "&if(hour(A1-now())>1,"Hours","Hour")&" : "&MINUTE(A1-now())&" "&if(MINUTE(A1-now())>1,"Minutes","Minute")
