time increments

  1. H

    Highlighting cells in 20 minute increments.

    I would like cell IJK3 highlight itself at 20:00 then IJK4 become highlighted at 20:20 and for IJK3 to go back to being not highlighted at 20:20. At 20:40 I would like IJK5 to become highlighted then IJK4 to go back to being not highlighted. At 21:00 I would like for IJK6 to be highlighted and...
  2. M

    30 minute time increments randomly starts adding seconds

    I have 30 minute interval data (date and time) and I want to copy the date and time formula down the column so that it increments by 30 mins. The time format is hh/mm/ss and there are no seconds. This seems to work ok until randomly it starts adding seconds as well which requires you to stop...

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