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.
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.