Rounding To Nearest 10 Worksheet

Excel's adeptness to add and decrease time ethics makes it a able apparatus for tracking abstracts that involves hours and minutes. But if you appetite to annular the account in your worksheet, you can't use Excel's rounding functions in the accustomed fashion, back the appliance food time ethics abnormally than it does approved numbers. By alignment your rounding blueprint or action about the time format, however, you can calmly annular to the abutting minute, or alike annular in beyond increments, such as back you appetite to bill a applicant in 15-minute blocks.

Abutting Minute

Format an abandoned corpuscle application a time format. For example, if you appetite to appearance hours and account only, right-click the cell, baddest "Format Cell," baddest "Custom," and again access "[h]:mm" (without quotes) into the Type field.

Type or adhesive the afterward blueprint into the abandoned cell:

=TIME(HOUR(A1),(MINUTE(A1) IF(SECOND(A1)>=30,1,0)),0)

Replace all instances of "A1" with the corpuscle abode of your aboriginal time value.

Press "Enter." The consistent amount is angled to the abutting minute.

Abutting 15-Minute Accession

Format an abandoned corpuscle application a time format.

Type or adhesive the afterward blueprint into the abandoned cell:

=TIME(HOUR(A1),MROUND(MINUTE(A1),15),0)

Replace all instances of "A1" with the corpuscle abode of your aboriginal time value. If you adopt to annular the amount to addition increment, alter "15" with a altered number. For example, to annular to the abutting hour, alter "15" with "60".

Press "Enter." Excel circuit the aboriginal amount up or bottomward to the abutting 15-minute (or other) increment.

Abutting Highest Accession

Format an abandoned corpuscle application a time format.

Type or adhesive the afterward blueprint into the abandoned cell:

=TIME(HOUR(A1),CEILING(MINUTE(A1),15),0)

Replace all instances of "A1" with the corpuscle abode of your aboriginal time value. If you adopt to annular the amount to addition accession besides 15 minutes, alter "15" with a altered number.

Press "Enter." In this example, Excel circuit the aboriginal amount up to the abutting 15-minute increment. You can additionally alter "CEILING" with "FLOOR" in this blueprint to annular the account bottomward to the abutting 15-minute increment.

References

Warnings

Writer Bio

Alan Sembera began autograph for bounded newspapers in Texas and Louisiana. His able career includes stints as a computer tech, advice editor and assets tax preparer. Sembera now writes abounding time about business and technology. He holds a Bachelor of Arts in journalism from Texas A&M University.

Rounding To Nearest 2 Worksheet - Rounding To Nearest 10 Worksheet | Delightful to help our blog site, in this time I will demonstrate with regards to Rounding To Nearest 10 Worksheet .