View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi what do you mean exactly by
" Each time the production changes the cumulative time should restart."
with the first line of your example
A 05:15 5:15

do you want to see this ....
A 07:30 0

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"68magnolia71" wrote in message
...
Hello you all,

I have the following problem with a production sheet:
A B, C, etc =the names of thr products
next column = production time
next column = addition of production times. Each time the production
changes
the cumulative time should restart. Have tried a couple of function like
SUMIF but never succeeded.
I 'll be gratefull for any suggestion

68magnolia71


A 05:15 5:15
A 06:15 11:30
B 07:15 7:15
C 08:15 8:15
C 09:15 17:30
C 04:15 21:45