Rounding Times 1

[dakeb]

Guys,

I couldn't find the answer to this by searching.

If I have a time enterered into a cell as hh:mm is there a way of rounding the time up or down automatically to the nearest quarter-hour (i.e. Excel chooses which way to round it)?

e.g. if the time entered is 18:23, Excel must round it up to 18:30, but if it is entered as 18:22 Excel must round it down to 18:15.

Thanks,

Dave

 

[bernoullies123]

google search....

http://www.mrexcel.com/td0024.html

 

[dakeb]

Brilliant, thanks.