Time slots

[hsandeep]

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.

 

[hsandeep]

clicking 'here' gives [h=1]Cannot connect to the real www.dropbox.com[/h]Is your above formula working?

 

[Vidar]

The time here is now 8:33. The cell Q1 is higlighted With the time 8:30. I Guess I would say that my formula is working alright.
If you format a cell With a time to number, does it convert to a decimal value below 1?
Try this link to download my example
https://dl.dropbox.com/s/py96avlzgqq3k6n/Time CF.xlsx?dl=0

 

[hsandeep]

I am trying to download... Meanwhile for time=8.33 the cell R1 should get highlighted with the value 9.00 since 8.33>8.30<=9.00

 

[Vidar]

We'll sort that out once you get the formula working