Percentage function help

O

oxicottin

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!!!
 
D

daddylonglegs

If your delay is in cell A1 and entered as a time, i.e. in h:mm format

=A1/"08:00"

format as percentage

You could also have 08:00 in a cell, say B1 and use

=A1/B
 
O

oxicottin

Thanks!! ill try it. Here is another question? I have a row of cells
that I want to put the delay time in lets say 04:36 hours/minutes. How
do I automaticly have the : in each cell so I can just enter the
hours/minutes it wasnt running? Here is another question, at the bottom
of those hours/min cells I need to total up all the time the machines
were down but it needs to be in hours and minutes. I have tried it and
after 24hours it resets back to 00:00 I need it not to reset and to
keep going. Example: 28:36 hours/minutes. Thanks!!!
 
D

daddylonglegs

You can't do that first part without VBA (a macro). As for your secon
question, you need to format the cell for elapsed time i.e. custo
format as [h]:m
 
O

oxicottin

thanks for the help but I ment can you explain the formula for elapsed
time? I just want to add a row of cells that contain hour/min and be
able to go over 24 hours and not reset back to 00:00 THANKS!!
 
D

daddylonglegs

I'm assuming you have the correct formula, some kind of SUM, you don't
need to change that but you need to change the formatting of the cell
so that it will display times over 24 hours ("elapsed time")

Format > Cells > Number > Custom

type [h]:mm in the box
 
O

oxicottin

Oh I see!! Im using =SUM(K6:L20) to get a total time and then I go to
the box and select Format>Cells>Custom>[h]:mm ? It worked but I cant
find or dont have a [h]:mm I have a [h]:mm:ss which gives seconds and I
dont want seconds. Where is the other one located (microsoft
2003)Thanks!!
 
P

Peo Sjoblom

As Daddylonglegs said use custom format and type in [hh]:mm or select the
built in format, then click custom and click at the end in the format box
and backspace off the :ss at the end

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

Portland, Oregon
 
Top