Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Calculations | Excel Worksheet Functions | |||
time interval calculations in excel | Excel Discussion (Misc queries) | |||
rounding time question | Excel Worksheet Functions | |||
Time calculations & text conversions | Excel Discussion (Misc queries) | |||
Time Sheet calculations | Excel Worksheet Functions |