Skip to content

Instantly share code, notes, and snippets.

@mdiener21

mdiener21/round_nearest_quarter_hour

Created December 3, 2018 11:14
Show Gist options
  • Save mdiener21/8a24fed03c023999ebfa6031661c5741 to your computer and use it in GitHub Desktop.
Save mdiener21/8a24fed03c023999ebfa6031661c5741 to your computer and use it in GitHub Desktop.
Download ZIP
Formulat for Libre Office Sheets round a duration value to the nearest quarter hour
Raw
round_nearest_quarter_hour
# sheets formula to round the value in cell F2 to the nearest quarter hour
=HOUR(F2) + (MROUND(MINUTE(F2),15)/60)
if 1:18:33 is the duration the result is 1.25.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment