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


"Terry Bennett" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>

[Sandy Mann]

Terry,

Try:

=CEILING(G22,"0:15")

or

=ROUNDUP(G22*96,0)/96




"Terry Bennett" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>

[Bob Phillips]

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

--

HTH

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


"Terry Bennett" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>