add two numbers in same cell together

's Computer Specifications

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.

's Computer Specifications

=--(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" <(E-Mail Removed)> wrote in message
news:BD08DB02-7A7C-43AE-8B32-(E-Mail Removed)...
>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.

's Computer Specifications

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.

's Computer Specifications

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

's Computer Specifications

>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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
add multiple numbers in one cell with those numbers remaining visi	TD	Microsoft Excel Worksheet Functions	7	28th May 2009 09:41 PM
how to extract numbers from imported cell with text and numbers?	=?Utf-8?B?anlpbg==?=	Microsoft Excel Misc	3	28th Mar 2007 01:14 PM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?	C-Man23	Microsoft Excel Worksheet Functions	3	19th Jan 2006 09:52 AM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up?	C-Man23	Microsoft Excel Worksheet Functions	1	9th Jan 2006 01:23 PM
filtering out a string of numbers out of a cell with text and numbers	brucejd	Microsoft Excel Misc	2	6th Aug 2004 12:03 AM