Rounding Time Calculations

[Terry Bennett]

I have a spreadsheet which calculates times that a vehicle takes to travel
from one destination to another at a variable speed input.

I need to be able to round-up the times to the nearest 15 minutes, ie; if
the calculation shows an arrival time of 11:34, I need to round this to
11:45.

Any ideas?

 

[PC]

With the arrival time in A1 try this formula

=CEILING(A1*24,0.25)/24

PC

 

[Sandy Mann]

Terry,

Try:

=CEILING(G22,"0:15")

or

=ROUNDUP(G22*96,0)/96

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.Rounding.html#time

--

HTH

RP
(remove nothere from the email address if mailing direct)