add two numbers in same cell together

[Guest]

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.

 

[Bob Phillips]

=--(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)

 

[Guest]

As long as there is no nightwork try this:-

=12-(LEFT(A1,1))+RIGHT(A1,1)

Mike

 

[Rick Rothstein \(MVP - VB\)]

I have a column that has scheduled times in it (i.e. 8-6) I would like

As long as there is no nightwork try this:-

=12-(LEFT(A1,1))+RIGHT(A1,1)

Sure hope there is no one starting work between 10am and noon.<g>

Rick

 

[Rick Rothstein \(MVP - VB\)]

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.

=MOD(12+RIGHT(A1,LEN(A1)-FIND("-",A1))-LEFT(A1,FIND("-",A1)-1),12)

Rick

 

[Guest]

That should do it..Thanks!

=MOD(12+RIGHT(A1,LEN(A1)-FIND("-",A1))-LEFT(A1,FIND("-",A1)-1),12)

Rick