You are here: HomeExcelTutorials

# rounding to the nearest .25

## rounding to the nearest .25

Price: FREE

I am using a spreadsheet as a time card. I am using military time. At the end of the day I need it to round to the nearest quarter hour (.25, .50, .75 or.00) how do I accomplish this?

Visit publisher's web-site: rounding to the nearest .25

Category and Tags: ExcelTutorials :

## Related Tutorials

### Rounding to the nearest 5

Free: Yes
Tags: Excel ›

I have a long list of prices which I need to round to the nearest £5. What's the best way of doing this?

### "Rounding" to nearest 5 cents

Free: Yes
Tags: Excel ›

Am trying to find a formula which will "round" a dollar/cents value to the nearest 5 cents. Have tried all the "rounding" formula I could find but can only get to the nearest 10 cents.
Reason for question is that in Australia our smallest denomination coin is 5 cent piece.

### rounding to the nearest quarter cent

Free: Yes
Tags: Excel ›

the question was just asked to me about rounding the cell value (formatted in currency) to the nearest quarter cent, i.e. \$8.16 > \$8.25, \$7.95 > \$8.00.
can this be done?

### Rounding Time to the nearest decimal of a second

Free: Yes
Tags: Excel ›

Im trying to figure out a formula to round my times in my spreadsheet to the nearest decimal. For example I have:
00:00:00.283 --> 00:00:00.30 (desired)
00:00:00.385 --> 00:00:00.40 (desired)
00:00:01.215 --> 00:00:01.20 (desired)
00:00:01.625 --> 00:00:01.60 (desired)
I know to round to the nearest second you'd use =ROUND(A1*(24*60*60,0)/(24*60*60)
with the 13:30:55 format. (I don't think this would display the decimal)

### Rounding to nearest half hour

Free: Yes
Tags: Excel ›

Does anyone know how to create a formula that will round time values to the nearest half hour and show only one decimal place? For example.1.25 hours would round to 1.5 hours.

## Related Applications & Scripts

### Geographic Distance and Azimuth Calculator

Free: Yes
Tags: PHP › Excel Geolocation

GeoCalc is a PHP and (MySQL) API that is useful in performing distance calculations between two distinct points on the earth's surface. Used in most GIS (Geographic Information Systems), these are standard algorithms with various levels of accuracy. Simple example of uses for this software would be to find the nearest store location to you, or finding the straight-line distance between two points on a map.

### Calculate distance between US zip codes

Free: No
Tags: PHP › Excel Zip Code Locators

We offer full US zip (post) code SQL database with coordinates (longitude, latitude) and names of postcode location (states and towns/cities), in total over 41.000 records. You can use this data base to calculate distances between two zip codes within US territory or find something in certain radius. For example you have database of late night shops (including addresses with zip codes) and you want to find nearest shops from your house within 10 miles radius no problem thats where this database comes in. Another wide used example is dating Websites, where you can search for persons within certain radius.

### Range Search by location

Free: No
Tags: PHP › Excel Geolocation Web Search

This script return all cities in selected range and address, is useful when searching nearest city or point of interest like shop. Simply pass a location and the search range and it will return cities and distance. The script use Yahoo API for geocoding location, the pack include also sql table for local database, you must insert geolocation data into it.

### AspJpeg: ASP and ASP.Net image-management

Free: No

AspJpeg is an easy-to-use component that enables you to create high-quality image thumbnails in just a few lines of code. Features: Support for three popular image resizing algorithms (Nearest-Neighbor, Bilinear and Bicubic); Resultant thumbnails can be saved to disk or sent directly to client browser for better performance; Image sharpening, cropping and flipping; Access to the size information of source images; Adjustable degree of JPEG compression; and currently, only the JPEG format is supported.
AspJpeg is a server component that will help your ASP or ASP.NET applications with all their image-management needs. With AspJpeg, you can create high-quality thumbnails, logo-stamp photographs, extract metadata information from images, crop, enhance, rotate, convert, and much more.

### Currency Server

Free: No

Currency Server was designed to be the most advanced currency-enabling component on the market. It provides exchange rate information and currency internationalization, conversion and rounding services via COM/ActiveX, .NET and SOAP Web services, and Ajax-style scripting. Currency Server supports more clients, more platforms, and a larger number of independent providers of exchange rate data than other tools.
By working locally rather than relying on remote servers for each transaction, Currency Server provides a unique level of performance, reliability and independence. The service is always available to satisfy thousands of information and conversion requests per second. Support for a variety of data providers (both free and subscription-based) and advanced administration notification options assure fault tolerance and peace of mind.