MAKING A SIMPLE TIME IN, TIME OUT COUNTER in MS Excel

MAKING A SIMPLE TIME IN, TIME OUT COUNTER

1.
2. Apply Formatting accordingly
A1 - Category: Date, Type: 3/14/01
B1 - Category: Time, type: 1:30 PM
C1 - Category: Time, type: 1:30 PM
D1 - Category: Number, use two decimal places

3. Input Date, Time in and Time out

4. For cell D2, apply the following formula
=IF(C2=B2, 24,MOD(C2-B2,1)*24)