To all those who have helped me in the past with the excel sheet I'm making, thank you. I just made a few tweaks to make my other tables work better so some of the stuff you showed me dose not work.
This is my standings sheet
<colgroup><col width="70" style="width: 53pt; mso-width-source...
I used Conditional Formatting to color code the Task List by Due Date (overdue, last week, this week, next week). How can I use it to remove the colors when any text is placed in the Completed column?
<tbody>
</tbody>
<tbody>
Completed
Due
TASK
10/7/2017
data
10/24/2017
data...
Im trying to figure out a excel function that would capture the "total number of minutes" based of the following criteria.
Start Day
End Day
Start Date Time
End Date Time
Total number of minutes
10/4/2017 0:00
10/4/2017 23:59
10/4/2017 22:00
10/4/2017 23:00
90...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.