LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default disperse amount across multiple cells without fractions

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy multiple records based on criteria or total amount David Excel Discussion (Misc queries) 22 July 29th 09 10:58 PM
formatting cells fractions - HELP Twicebest Excel Discussion (Misc queries) 7 February 29th 08 02:47 PM
return in fractions with multiple divisors, linear rflock Excel Worksheet Functions 2 August 21st 07 01:43 AM
CONCATENATE Cells Formated as fractions Northcoast Excel Worksheet Functions 4 April 27th 06 05:24 PM
Disperse one worksheet into several... Frantic Excel-er Excel Discussion (Misc queries) 3 June 28th 05 04:16 PM


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"