Hi

I take it that you want decimal time! Format B1 & C1 as text, you can then enter "0", ie 0715.

In D1: =MROUND(MOD((--REPLACE(C1,3,0,":"))-(REPLACE(B1,3,0,":")),1),"00:15")*24

and format the cell "General".

Or for proper time

=MROUND(MOD((--REPLACE(C1,3,0,":"))-(REPLACE(B1,3,0,":")),1),"00:15")

and format as time.

Kevin