Please HELP me with this...

[marcX]

I want to round the time like this

HH:MM
IF 00:05=00:15
00:10=00:30
00:45=01:00

or
HH:MM
IF 01:05=00:15
01:10=00:30
01:45=02:00

But if the condition does not meet, it will automatically round down descending

ex:1
If 01:04 then it should be

01:04=01:00

ex:2
If 01:44 then it should be

01:44=01:30




PLEASE PLEASE!!!

I realy need it ryt away!

[Bob Phillips]

You need to explain that. Why does the first go to the next quarter hour up, but the second goes to the next half hour up?