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

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/B1


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=514055

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


--
oxicottin
------------------------------------------------------------------------
oxicottin's Profile: http://www.excelforum.com/member.php...o&userid=31702
View this thread: http://www.excelforum.com/showthread...hreadid=514055

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=514055

can you explain im new to excell? Thanks!!


--
oxicottin
------------------------------------------------------------------------
oxicottin's Profile: http://www.excelforum.com/member.php...o&userid=31702
View this thread: http://www.excelforum.com/showthread...hreadid=514055

Here's a link how to apply it using VBA

http://www.cpearson.com/excel/DateTimeEntry.htm

a farmer's almanac version would be to temporary make a change in
autocorrect, put a period and replace it with
a colon, that way you can use the numeric keypad and type 12.30 and it will
change to 12:30
just remember to change back when you're done

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

Portland, Oregon




"oxicottin" wrote
in message ...

can you explain im new to excell? Thanks!!


--
oxicottin
------------------------------------------------------------------------
oxicottin's Profile:
http://www.excelforum.com/member.php...o&userid=31702
View this thread: http://www.excelforum.com/showthread...hreadid=514055