ExcelBanter - Rouding up times. e.g. 7:33 --> 7:35

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Rouding up times. e.g. 7:33 --> 7:35 (https://www.excelbanter.com/excel-discussion-misc-queries/26933-rouding-up-times-e-g-7-33-%3E-7-35-a.html)

Najeeb

Rouding up times. e.g. 7:33 --> 7:35

I have a clumn of times. How do I round them up to the nearest multiple of 5
minutes? I know of ROUNDUP.. but how do I do it with times?

Eg.
5:03
5:05
5:06
5:08
5:09
5:09
5:09

goes to:

5:05
5:05
5:10
5:10
5:10
5:10
5:10

JE McGimpsey

One way:

=CEILING(A1,"0:5:0")

In article ,
Najeeb wrote:

I have a clumn of times. How do I round them up to the nearest multiple of 5
minutes? I know of ROUNDUP.. but how do I do it with times?

Eg.
5:03
5:05
5:06
5:08
5:09
5:09
5:09

goes to:

5:05
5:05
5:10
5:10
5:10
5:10
5:10

All times are GMT +1. The time now is 08:15 PM.