+ Start a Discussion
NAlmolaNAlmola 

how to create 15 minute increment values

Hello,

Am getting various enquiries from my colleagues about recording and working with different time values in Salesforce so it's really a trial at the moment.

One of the guys have asked to work in increments of 15. At the moment most of the time based fields are in minutes. Am looking for a formula that rounds up the value to increments in 15. For example

0 to 15minutes = 1
16 to 30minutes = 2
31 to 45minutes = 3
46 to 60minutes = 4
61 to 90minutes = 5
91 to 114minutes = 6
115 to 129minutes = 7

and so on and so forth


Kind Regards

N
Matt WhalleyMatt Whalley
if you wanted to do 1-14,15-29, 30-44, etc, then just divide by 15 + 1.
NAlmolaNAlmola
that doesn't make sense.... 14/15 + 1 = 1.93, which rounded up is 2. Not the value am looking for. Have I missed a trick?