Time slots

H

hsandeep

Well-known Member
Joined
Dec 6, 2008
Messages
1,213
Office Version
  1. 2010
Platform
  1. Windows
  2. Mobile
I am using 48 columns to show the time slots of a day of 30 minutes each in cells A1:A48 as follows:
A1 A2 A47 A48
0.30 1.00 23.30 24.00

Here the values are punched as numerical values.
1.00 means when current systems's time >0.30 & <=1.00
Similarly for 10.30 means when current systems's time >10.00 & <=10.30

How to highlight the background color using CF when system's time is in that time period. ONLY.

Thanx in adv.
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Sort by date Sort by votes
Select the range A1:A48 starting With A1 (important).
Use this formula in CF, and set the formatting as you please.
=AND(A1+0,020833>TIME(HOUR(NOW()),MINUTE(NOW()),0),A1<=TIME(HOUR(NOW()),MINUTE(NOW()),0))
 
Upvote 0
It shows background color BUT ONLY in A1 while system time is 16.27 & A1=0.30. It should have shown in AG1 (=16.30)
 
Upvote 0
I am sorry Vidar The values are punched in cells Starting A1, B1, C1 & so on.......
 
Upvote 0
It highlights A1 (containing 0.30) which is WRONG!
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Using VBA to Flag and Calculate Overlapping Shift Times
Replies
0
Views
33
Snort
S
L
  • Solved
Add date to existing time based conditional format
Replies
5
Views
738
Fluff
Fluff
C
  • Solved
Create Function that Calculates a Value Relative to Original Price and Also Constructs a Price Ladder
2
Replies
10
Views
874
NdNoviceHlp
NdNoviceHlp
W
  • Solved
Removing Data Validation List Items Once Selected In Another Cell
Replies
3
Views
398
James006
James006
A
  • Question
First VBA Project - is there a better way to write this code?
Replies
0
Views
2K
akshay27
A

Forum statistics

Threads
1,214,951
Messages
6,122,442
Members
449,083
Latest member
Ava19

Share this page

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