Skip to content

Instantly share code, notes, and snippets.

@omergorur

omergorur/excel-round-time-to-nearest-15-minutes.txt

Created April 20, 2026 16:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save omergorur/9ad8b0c158f35146526a427bb2518c0b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save omergorur/9ad8b0c158f35146526a427bb2518c0b to your computer and use it in GitHub Desktop.
Download ZIP
Excel: Round Time to the Nearest 15 Minutes
Raw
excel-round-time-to-nearest-15-minutes.txt
=ROUND(A1*(24*60)/15,0)*15/(24*60)
Raw
excel-saati-en-yakın-15-dakikaya-yuvarla.txt
=YUVARLA(A1*(24*60)/15;0)*15/(24*60)
@omergorur

omergorur commented Apr 20, 2026

Copy link
Copy Markdown
Author

Excel: Round Time to the Nearest 15 Minutes

image

Round any time value to the nearest 15-minute interval.

  • Column A contains the original time values.
  • Column B returns the time rounded to the nearest 15 minutes.
  • Change 15 to any interval you need (e.g., 5, 10, 30, 60).
  • Format cells as h:mm to display as time.
=ROUND(A1*(24*60)/15,0)*15/(24*60)

Excel: Saati En Yakın 15 Dakikaya Yuvarlama

Herhangi bir saat değerini en yakın 15 dakikalık dilime yuvarlar.

  • A sütunu: Orijinal saat değerlerini içerir.
  • B sütunu: En yakın 15 dakikaya yuvarlanmış saati döndürür.
  • 15 yerine istediğiniz aralığı yazabilirsiniz (ör. 5, 10, 30, 60).
  • Hücreleri ss:dd olarak biçimlendirin.
=YUVARLA(A1*(24*60)/15;0)*15/(24*60)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment