Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Hello, Im in need for some help with a spreadsheet for work! Im having several problems and we will start with this one first. OK, we run machines for an 8 hour shift and these machines are down or not running for a few hours out of the 8 hour shift. I want to be able to put a number in a cell called "Delay" lets say 4:00 hours to make it easy and in the next cell over called "%" I want it to give me the % that the machine wasnt running for the 8 hours. The answer is 50%. Please help!! I have another one but lets do one at a time! Thanks!!! -- oxicottin ------------------------------------------------------------------------ oxicottin's Profile: http://www.excelforum.com/member.php...o&userid=31702 View this thread: http://www.excelforum.com/showthread...hreadid=514055 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change percentage function to less than a hundredth? | New Users to Excel | |||
UDF help please | Excel Discussion (Misc queries) | |||
Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |