=--(RIGHT(A21,LEN(A21)-FIND("-",A21)))-LEFT(A21,FIND("-",A21)-1)+(--(RIGHT(A21,LEN(A21)-FIND("-",A21)))-LEFT(A21,FIND("-",A21)-1)<0)*12

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"leejb" wrote in message
...
I have a column that has scheduled times in it (i.e. 8-6) I would like the
column next to it to list the total number of hours that this equals (in
this
case 10). I could create a seperate column for each time in/out, but I am
trying to keep the sheet as simple to the user as possible. currently the
scheduled column is formatted as text.