Conditional Formatting within a Time Sheet



Can someone help me with this one:
I am using a Excel time sheet with input in time format. I would like a
formula that can extract out the minuets and dived it in to three categories:
1-10 minutes and 31-40 minutes conditional formatting in red color
11-20 minutes and 41-50 minutes conditional formatting in yellow color
21-30 minutes and 51-59 minutes conditional formatting in green color.

Example: Time 02.08.00 should be stript down to 00.08.00 and then color the
cell in red.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question