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

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


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

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


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

Oh I see!! Im using =SUM(K6:L20) to get a total time and then I go to
the box and select FormatCellsCustom[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!!


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

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




"oxicottin" wrote
in message ...

Oh I see!! Im using =SUM(K6:L20) to get a total time and then I go to
the box and select FormatCellsCustom[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!!


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