Perhaps in E7 =D7-C7-QUOTIENT(D7-C7,5)*0.5 (providing time is entered in decimal as you did)