add two numbers in same cell together

L

leejb

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.
 
B

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)
 
R

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)
Click to expand...

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

Rick
 
R

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.
Click to expand...

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

Rick
 
Top