I'm having problems. On some cells that I entered 1:00 it's rounding it up to
1:05. Is there something wrong?? There's no decimals because I entered the
time 1:00 it's not giving it out as a formula.

"GEM" wrote:

Thank you!!!!!!!!!! Just for general knowledge... and to round that number
down???

"David Biddulph" wrote:

=CEILING(A2,TIME(,5,))
--
David Biddulph

"GEM" wrote in message
...
How can I round time UP to the nearest 5 min. I need to have the report in
numbers divisible by 5 and the time should always go up. 1:30, 1:35, 1:40,
1:45.

For example,

1:41 round it to 1:45
1:43 round it to 1:45
1:46 round it to 1:50
1:48 round it to 1:50
1:40 is kept at 1:40
1:50 is kept at 1:50