=(MOD(B1-A1,1))*24



http://www.mrexcel.com/forum/excel-questions/341459-calculating-difference-between-two-times.html