Is there a way in a formula to add an unknown later input number

[Chris1972]

I am looking for help to create a formula to do the following scenario. In let say cell B3 I want to be able to enter SDO + (a changing value) and be able to transfer it to another cell on the same sheet say B50.

For example an employee works their day off "SDO" which equals 8 hours of overtime but sometimes they work over the 8 hours thus would have to add the additional time which could vary from time to time.

So what I have done is use the formula =if(B3="SDO",8,0) which makes it to where the SDO inputed in B3 equals the 8 hour value but say the employee worked 9.45 hours how would I make it to where I can add the additional 1.45 hours to the 8 hours in B3 and make it come out to 9.45 in B50?

[Glenn Kennedy]

It's not clear to me exactly what you intend to enter in B3. So.... please do so in a sample sheet and post it (along with a fewother examples AND your expected results).

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[FerdyHar]

You would need an additional helper column where you enter the overtime hours. You could, that way, change your formula to

Please Login or Register  to view this content.

The cell you put this formula in should be formatted as a time. B3 holds the word SDO (or not) like you had before. C3 holds the overtime hours (also time formatted)

Ferdy

[Kaper]

If I understood well your idea of:

I want to be able to enter SDO + (a changing value)

then try:

Please Login or Register  to view this content.

for SDO or SDO8 or SDO8.0 it shall return 8, but for SDO9.5 there will be 9.5

[Chris1972]

In Kaper's post that is exactly what I was needing but can someone explain to me what all that means on the formula to help me better understand the values or post an example of the same thing applied to make c4 do the same thing and maybe I can figure it out.

[davsth]

if the value in the cell is just SDO, then return 8, otherwise you want the value from a cell that starts at the 4th character to the end. However the mid function returns values as text so -- has the strange property of turning text to a number. If it does not start SDO then return 0

I usually multiply by 1 which has the same effect

=if(left(B3,3)="SDO",if(len(B3)=3,8,mid(B3,4,1000)*1),0)

[Chris1972]

Perfect. Thank y'all for the help.