How do I round minutes to the nearest 15 minute increment?

D

DJL

On timesheets I need to round up or down and the formula in InfoPath rounds
to the nearest integer or hour and I need it to be in 15 minute increments.
 
F

Franck Dauché

Hi,

This a math question, right?
n is a number in minutes from 1 to 59, t gives you 15; 30; 45; 60
t = ((n / 15) + ((n % 15)/15 + 1))*15;

Regards,

Franck Dauché
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding to closest 15 minute increment 2
Round time to nearest 15 minutes in decimal format 4
Custom validation rule - must be 15 increment of time 1
Round up or down to nearest 5, but not 10 2
Rounding Time to Nearest 5 Minutes 1
Round up to nearest 25 or 50? 6
Create database based on 24 hour time; 15 minute increments 1
Rounding hh:mm to nearest 15, 30, 45 minutes 4

Top