Rounding Time Calculations
 

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?

With the arrival time in A1 try this formula

=CEILING(A1*24,0.25)/24

PC


"Terry Bennett" wrote in message
...
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?

Terry,

Try:

=CEILING(G22,"0:15")

or

=ROUNDUP(G22*96,0)/96




"Terry Bennett" wrote in message
...
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?

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

--

HTH

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


"Terry Bennett" wrote in message
...
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?