IF Formula advice

"As you may know"
How shall we know?

As for merit - the effect you want can be easily obtained in excel with conditional formatting.

PS. frank advice (excerpt from forum rules):
Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

I suggest you post a sample workbook instead of a picture of it. Not much anyone can do with a picture except look at it.

Regards, TMS

See the updated sample workbook. You should record real times rather than text strings.


Regards, TMS

Originally Posted by TMShucks

See the updated sample workbook. You should record real times rather than text strings.


Regards, TMS

Thank you so much! I see what you've done. As you can see in the other pages, is there a possibility to convert the 'text strings' to real times as I try it and it changes to 00:00:00

Edit: Playing around with it and I see how it works, yet again, thanks so much!

Sorry, it's tedious but probably just as quick to edit each of the times to add colons and change the format of the cell to Time.

A better option might be to copy and rename sheet 12 and then re-input the data from the earlier sheets.

Regards, TMS



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.