MAKING A SIMPLE TIME IN, TIME OUT COUNTER
1.
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)
