I need to modify this >>> =IF(OR(ISTEXT(B5),ISTEXT(B6)),0,MOD(B6-B5,1)*24)

[see attached]

In an electronic spreadsheet I am making, I need "text" to equal 0. This is why I was using:

=IF(OR(ISTEXT(B5),ISTEXT(B6)),0,MOD(B6-B5,1)*24)

I have found two exceptions to this rule, and they are labeled "SCHOOL" AND "TRAINING". When B5 or B6 is equal to either of these two, I need the cell containing the formula to equal whatever number has been entered into B12.

Thank you very much in advance to anyone who is able to assist!

Post the

electronic spreadsheet

or part thereof, and not the old fashioned pen and paper, sorry screenshot.

It makes life so much simpler, most of us prefer it that way, we are very lazy and dislike extra work ..... ....

Originally Posted by Marcol

Post the and not the old fashioned pen and paper, sorry screenshot.

It makes life so much simpler, most of us prefer it that way, we are very lazy and dislike extra work ..... ....

I try to avoid attaching the actual document as it usually leads to ridicule. I consider myself a decent user of excel, but since I am self taught I often have an unorthodox approach to certain problems which lead others to say "Why the hell did you do it that way?" This is why I like to make the spreadsheet work perfectly, and then hide/lock ALL of my work for no one to see :-)

See Attached Spreadsheet & get your jabs in :-/

(Please note: The actual timesheet portion of the spreadsheet, A1 through S34, looks exactly like the printed one that is done by hand today. It would have been much easier to bring my creation to life if I was not constrained like this. It is also why there are so many merged cells.)

OMG.

You weren't kidding.

I'm not saying I like the way you're doing this but you can simply insert the logic of one into the other - i.e.
=if(or(b5="school",b5="training",b6="school",b6="training"),b12,0)

goes in place of 0 in

=IF(OR(ISTEXT(B5),ISTEXT(B6)),0,MOD(B6-B5,1)*24)

giving

=IF(OR(ISTEXT(B5),ISTEXT(B6)),if(or(b5="school",b5="training",b6="school",b6="training"),b12,0),MOD(B6-B5,1)*24)

Yuck, I feel dirty

Hmmm ......

Aren't you confusing ridicule with criticism?

It would not be the first time, nor will it be the last, that I have answered a thread, and them someone else comes up with a better solution.

I accept this as constructive criticism not ridicule.
Ultimately this benefits both me and the OP ......bonus!

You might be surprised by how many people on this forum that are self-taught. You are not alone.

However if, as you say

I like to make the spreadsheet work perfectly, and then hide/lock ALL of my work for no one to see

how do you expect to progress?

If everybody adopted this approach where do you think we might end up?

My criticism would definitely fall under 'ridicule' not 'constructive criticism' - I'm too lazy to mend all the world's ills... and ridicule is funner.