Time to hours

B

BF

After spending two hours I finally decided to come here. All I want to
do is be able to enter an in time of day and an out time of day and have
the number of hours calculated. It just can't be that hard, but I am not
able to figure it out.
Any help would be appreciated.

Bill
 
I

Ian Gilmore

Oneway that I use is.

In cell A1 enter 20:15
In cell A2 enter 01:30
In Cell A3 enter = MOD(A2-A1,1)

This will work for any time including those that cross midnight. Remember to
format the times correctly.
 
Top