Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet that calculates work time by day and job number.
Someone may have multiple entries on one day to different job numbers. We want to take the total overtime for the week (anything over 40) and disperse it over all the jobs. I have done this, but it does it in fractions. Even though I show only 1 decimal, the actual number is several decimal places. 116/13. How can I divide it but make it only have 1 decimal place. Like one can be 8.5 and the other 8.6 for a total of 17.1 instead of both of them being 8.55. start time(A) Stop time(b) total time(c) OT(d) - Total OT for week(d10) Any help would be greatly appreciated. I can send sample spreadsheet if you need it. Becky |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy multiple records based on criteria or total amount | Excel Discussion (Misc queries) | |||
formatting cells fractions - HELP | Excel Discussion (Misc queries) | |||
return in fractions with multiple divisors, linear | Excel Worksheet Functions | |||
CONCATENATE Cells Formated as fractions | Excel Worksheet Functions | |||
Disperse one worksheet into several... | Excel Discussion (Misc queries) |