Terry Bennett

Posts: n/a

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Time Calculations	Paul T	Excel Worksheet Functions	1	April 23rd 05 04:02 AM
time interval calculations in excel	Krishna	Excel Discussion (Misc queries)	6	April 8th 05 02:57 PM
rounding time question	lbfries	Excel Worksheet Functions	3	April 6th 05 08:23 PM
Time calculations & text conversions	Kenny Hubbard	Excel Discussion (Misc queries)	1	February 5th 05 10:15 PM
Time Sheet calculations	dkostel	Excel Worksheet Functions	2	November 23rd 04 10:11 PM

All times are GMT +1. The time now is 06:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us