I would recommend to you the feature of Excel help for a function (in this
case CEILING) that says "See Also".. It will show you the function that has
the opposite effect to CEILING, and it will also show you a number of
similar functions which may be useful to you in future.
--
David Biddulph

"GEM" wrote in message
...
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