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.
Which are the CF cells you want to use Ted?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I was trying to test it on Row179 Cells C to BC
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)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Excellent, Thanks for that
I'm going on to look at UserForms now so I may well be back
Posting Permissions
Reply With Quote
