I am working on making a worktime calculator to ensure that i know what my
employer should be entering. We clock in/out using 100ths of an hour
(x.00-x.99).
If a day's time (the fraction portion) falls .12 above a quarter hour (.00,
..25, .50, .75) it is rounded down to the lower quarter hour. If it is
..13-.24 above a quarter hour it is rounded up to the next higher quarter
hour. I am having problems figuring out how to operate on the decimal
portion and get the proper result (retaining the hour portion (or increasing
it by 1) and the new quarter hour portion.

One way:

=ROUND(A1*4,0)/4

In article ,
"maintchief" wrote:

I am working on making a worktime calculator to ensure that i know what my
employer should be entering. We clock in/out using 100ths of an hour
(x.00-x.99).
If a day's time (the fraction portion) falls .12 above a quarter hour (.00,
.25, .50, .75) it is rounded down to the lower quarter hour. If it is
.13-.24 above a quarter hour it is rounded up to the next higher quarter
hour. I am having problems figuring out how to operate on the decimal
portion and get the proper result (retaining the hour portion (or increasing
it by 1) and the new quarter hour portion.

You folks are amazing. Thanks a lot.
One further question: how do I access the referenced article?


"JE McGimpsey" wrote:

One way:

=ROUND(A1*4,0)/4

In article ,
"maintchief" wrote:

I am working on making a worktime calculator to ensure that i know what my
employer should be entering. We clock in/out using 100ths of an hour
(x.00-x.99).
If a day's time (the fraction portion) falls .12 above a quarter hour (.00,
.25, .50, .75) it is rounded down to the lower quarter hour. If it is
.13-.24 above a quarter hour it is rounded up to the next higher quarter
hour. I am having problems figuring out how to operate on the decimal
portion and get the proper result (retaining the hour portion (or increasing
it by 1) and the new quarter hour portion.

In article ,
"maintchief" wrote:

The "article" in question is your original post.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"maintchief" wrote in message
...
You folks are amazing. Thanks a lot.
One further question: how do I access the referenced article?


"JE McGimpsey" wrote:

One way:

=ROUND(A1*4,0)/4

In article ,
"maintchief" wrote:

I am working on making a worktime calculator to ensure that i know what
my
employer should be entering. We clock in/out using 100ths of an hour
(x.00-x.99).
If a day's time (the fraction portion) falls .12 above a quarter hour
(.00,
.25, .50, .75) it is rounded down to the lower quarter hour. If it is
.13-.24 above a quarter hour it is rounded up to the next higher
quarter
hour. I am having problems figuring out how to operate on the decimal
portion and get the proper result (retaining the hour portion (or
increasing
it by 1) and the new quarter hour portion.