Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to extract numbers from imported cell with text and numbers? | Excel Discussion (Misc queries) | |||
copy numbers from numbers+text cell | Excel Worksheet Functions | |||
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? | Excel Worksheet Functions | |||
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? | Excel Worksheet Functions | |||
extract numbers from cell containing text & numbers | Excel Worksheet Functions |