add two numbers in same cell together
 

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.

add two numbers in same cell together
 

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

add two numbers in same cell together
 

As long as there is no nightwork try this:-

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

Mike

"leejb" wrote:

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.

add two numbers in same cell together
 

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.

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

add two numbers in same cell together
 

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

add two numbers in same cell together
 

That should do it..Thanks!

"Rick Rothstein (MVP - VB)" wrote:

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