Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dividing hours
I I have created a word report linking 9 Excel workbooks each using 52
worksheets (Annual) Each workbook also has a calculation worksheet. I have been requested by my manager the following. Service annual hours = 52000 hrs cell A1 1) I need cells B1,B2,B3 to split cell A1 equally for a the three districts (annual) 2) Then each district say C1,C2,C3,C4 divide cell B1 (quarters) 3) I then need to divide C1 "for example" by 13 for the quarterly calendar period and print the results on each on the first 13 worksheet 4) this process is repeated for all the quarterly periods of the fiscal year. 5) lastly if the actual hours provided is greater than the planned hours I need it displayed in red how do I get the hours displayed in red if the manager uses more than her allotted hours? I can do this process quite easily as numbers but using hours are quite different. Please can you help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dividing hours to give days | Excel Worksheet Functions | |||
Date and Time Response- before/during/after Business hours | Excel Discussion (Misc queries) | |||
Can this adjusted GPA formual be accomplised? | Excel Discussion (Misc queries) | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions |