M
Macros The Black
Hi all,
Stuck on this one now. In my spreadsheet i have 3 columns that contain the
following info for my production machines
Total shift time (this will usually be 7:45 or 8:30 - formatted in hh:mm
format)
Downtime per shift (any value upto max shift time - formatted in hh:mm
format)
Kgs produced.
I would like to keep the time in hh:mm format as i do further calculations
on these - % downtime, total downtime, total shift hours etc (and also cos
it took be ages to figure out how to add up in time and i couldn't believe
how simple it was when i figured it out)
What i would like to be able to calculate is the actual production rate in
kgs/hr for the running itme of the machine
I have a calc running time=shift time-downtime : this works fine
Prod rate = kgs produced / running time
If i set shift time to 7:45, downtime to 2:45 - running time = 5:00
kgs prod = 10000, therefore prod rate = 2000 kg/hrs but calc gives me 48000
(presumably cos 05:00 it is converting to decimal or something ?)
Can anyone help me on this one please ??
-----------------------------------------------------------
question 2
i have a graph charting % downtime. this is set up for the full week but i
would like it to just display the data as we go along. the problem is that
it is displaying the lines at 0 for those days where data isnt available.
the column it is picking the data from also has a calc in it to not display
0's or errors. calc is =IF(C5="","",+C5/D5) where c5 and d5 represent lost
time/shift time.
If i delete this formula and leave the cell blank then the graph doesnt show
the point at all which is what i would like.
how do i get to this ?
Kind regards
Macros
(No more q's after this - i have racke dmy brains for hours trying to sort
these probs)
Stuck on this one now. In my spreadsheet i have 3 columns that contain the
following info for my production machines
Total shift time (this will usually be 7:45 or 8:30 - formatted in hh:mm
format)
Downtime per shift (any value upto max shift time - formatted in hh:mm
format)
Kgs produced.
I would like to keep the time in hh:mm format as i do further calculations
on these - % downtime, total downtime, total shift hours etc (and also cos
it took be ages to figure out how to add up in time and i couldn't believe
how simple it was when i figured it out)
What i would like to be able to calculate is the actual production rate in
kgs/hr for the running itme of the machine
I have a calc running time=shift time-downtime : this works fine
Prod rate = kgs produced / running time
If i set shift time to 7:45, downtime to 2:45 - running time = 5:00
kgs prod = 10000, therefore prod rate = 2000 kg/hrs but calc gives me 48000
(presumably cos 05:00 it is converting to decimal or something ?)
Can anyone help me on this one please ??
-----------------------------------------------------------
question 2
i have a graph charting % downtime. this is set up for the full week but i
would like it to just display the data as we go along. the problem is that
it is displaying the lines at 0 for those days where data isnt available.
the column it is picking the data from also has a calc in it to not display
0's or errors. calc is =IF(C5="","",+C5/D5) where c5 and d5 represent lost
time/shift time.
If i delete this formula and leave the cell blank then the graph doesnt show
the point at all which is what i would like.
how do i get to this ?
Kind regards
Macros
(No more q's after this - i have racke dmy brains for hours trying to sort
these probs)