You need to sign in to do that
Don't have an account?
NAlmola
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
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 Whalley
if you wanted to do 1-14,15-29, 30-44, etc, then just divide by 15 + 1.
NAlmola
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?