Roundin Time

[saud]

Please I need to Know How to Round a Time
after suming a time
if the time is 08:23 how could I Round it to 08:25
and if it's 08:22 I would like it to be 08:2

+----------------------------------------------------------------
| Attachment filename: example.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=364713
+----------------------------------------------------------------

 

[Peo Sjoblom]

One way

=ROUND(A1/TIME(,5,),0)*TIME(,5,)