how do i operate on the decimal portion of a number

M

maintchief

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.
 
M

maintchief

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

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

ROUND UP HOURS to the next quarter hour 2
Graph usage for times of day 0
Rounding to the nearest quarter (decimal) in a Pivot table 3
Excel Time Sheet - Rounding To Quarter Hours 2
Calculation of Overlap Outage Hours 17
convert decimal numbers to a fraction of an hour for payroll hour 4
ROUNDING TIME TO THE NEAREST QUARTER HOUR 2
Convert hr:min to decimal (payroll solution) 1

Top