Please HELP me with this...

marcX

New member
Joined
Oct 18, 2011
Messages
1
Reaction score
0
Points
0
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!
 
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?
 
Back
Top