numbers

[Bill H.]

I have a database of call times, and I want to round up the time (in secs)
to the next higher multiple of 6.

Is there an easy way to do this?

How?

Thanks!

 

[John Vinson]

I have a database of call times, and I want to round up the time (in secs)
to the next higher multiple of 6.

What's the datatype of the field? I'd suggest using Long Integer
seconds and using an expression such as

6*Fix([duration] / 6) + IIF(Fix([duration] / 6) < [duration] / 6, 1,
0)

 

[Bill H.]

datatype is long.

I have a database of call times, and I want to round up the time (in secs)
to the next higher multiple of 6.

What's the datatype of the field? I'd suggest using Long Integer
seconds and using an expression such as

6*Fix([duration] / 6) + IIF(Fix([duration] / 6) < [duration] / 6, 1,
0)

 

[Bill H.]

doesn't seem to quite work. Here's some numbers:

value value after formula
59 55
85 85
108 108
183 181
275 271

I have a database of call times, and I want to round up the time (in secs)
to the next higher multiple of 6.

What's the datatype of the field? I'd suggest using Long Integer
seconds and using an expression such as

6*Fix([duration] / 6) + IIF(Fix([duration] / 6) < [duration] / 6, 1,
0)

 

[Marshall Barton]

Try this:

6 * CLng(duration / 6)

Or, if you don't like that kind of rounding:

6 * Fix(Duration / 6 + .5 * Sgn(Duration))
--
Marsh
MVP [MS Access]

doesn't seem to quite work. Here's some numbers:

value value after formula
59 55
85 85
108 108
183 181
275 271

I have a database of call times, and I want to round up the time (in secs)
to the next higher multiple of 6.

What's the datatype of the field? I'd suggest using Long Integer
seconds and using an expression such as

6*Fix([duration] / 6) + IIF(Fix([duration] / 6) < [duration] / 6, 1,
0)

 

[Van T. Dinh]

I think John meant the formula:

6*( Fix([duration] / 6) + IIF(Fix([duration] / 6) < [duration] / 6, 1,0) )

Note the extra set of brackets. Another alternative id duration is ALWAYS >
0:

( ([Duration] - 1) \ 6 + 1 ) * 6

 

[John Vinson]

doesn't seem to quite work. Here's some numbers:

value value after formula
59 55
85 85
108 108
183 181
275 271

hmmm... rounding wasn't working as I expected! Try:

6*Fix([duration] / 6) + IIF([Duration] MOD 6 > 0, 1, 0)