time conditional-format

  1. C

    Reference,calculate and convert multiple cells with multiple options

    Hey Superstars, In a tab named "Schedule" i have a 'list' of text options (morning,afternoon,half day etc...). The source data for this in a sheet called "shifts". This has the shift (morning,afternoon) and then i have 2 additional fields (start and finish time). In the "hours" tab I have used...
  2. F

    Time of day adjusting color in cell

    Hello, I am working on a global schedule for technicians using Excel. I would like a way to have the color in the cell in front of the technician name to change based on the time of day. Also I would like for the cell in front the cell to show number of hours left until their work shift ends...
  3. S

    vba help for copy range every 15 minutes

    i get in my work sheet prices updated from exchange in row 2 every minutes for 30 cells i.e.from cell A2 to Z2 i want to copy value of this row copied every 15 minutes in same worksheet from row 3 onwards( or new rows ) for study of rate changes every minutes i use excel 2007 thank you for...
    • shahnanu
    • Thread
    • copy & paste rows macro - help now() time conditional-format vba - help
    • Replies: 14
    • Forum: Excel Questions
  4. R

    Time Calculation Problems: AVERAGEIFS for data inclusive between certain times, which may cross over midnight, duration may result in a negative numbe

    Good afternoon, I am trying to get the average time it takes for employees to be ready/available for their shift, with a separate column showing the duration (minutes and seconds) since some people understand that better. However, anything over 20 minutes before or after the shift begin time...
  5. P

    Conditional formatting with time-formats where one cell is a formula

    I'm trying to conditionally format a cell based on the comparison of two times. I've gotten it to work when both are hard numbers, like comparing 11:00 and 12:00. However, when one of them is the result of a formula, the conditional formatting doesn't seem to work. What am I doing wrong? I want...

We've detected that you are using an adblocker.

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.
Go back
Back
Top