| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i operate on the decimal portion of a number
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Rational exansion of a decimal number | Excel Worksheet Functions | |||
| converting number string to number with decimal | Excel Worksheet Functions | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| How do I change the number of decimal places displayed in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
