PDA

View Full Version : Solved: Times Now & Rounding



TedMosby
03-17-2009, 03:58 AM
I am trying to use the time now and fit it into a section of times on my schedule. My schedule is set out in 15min intervals. What I want to do is round the time down so it would fit in the interval

I have used these formula's

=ROUNDDOWN(F4*96,0)/96
=FLOOR(F4,1/96)

My Conditional Format looks to see if the Time interval = Time Now and then hopefully colours the Cell Red. But this isnt happening.

Where have I gone wrong?

Attached is a copy of the workbook.

Bob Phillips
03-17-2009, 04:02 AM
Which are the CF cells you want to use Ted?

TedMosby
03-17-2009, 04:09 AM
I was trying to test it on Row179 Cells C to BC

Bob Phillips
03-17-2009, 04:18 AM
The problem is that you are checking the time in row 173 against the (seemingly) time in L4. However, L4 refers back to F4, which refers back to DateParam4 ... BUT ... dateParam4 uses the NOW function, which is DATE AND TIME.

Either change DateParam4 to

=MOD(NOW(),1)

, or if that is not possible, change the CF formula to

=C$173=MOD($L$4,1)

TedMosby
03-17-2009, 04:44 AM
Excellent, Thanks for that :)

I'm going on to look at UserForms now so I may well be back