Hi guys,

This is my 1st using this forum so I'm sorry if I'm missing some houserules.

I made an hour registration form in visual basic with different types need to be calculated(preperation, production, packing, error and standing still)

so the format for the textboxes is 00:00 to fill in time.

To calculate the total time I seperated the hour and minutes with macros and they show up on the right of my table like this:

- .Cells(iRow, 19) = "=LEFT((TEXT(R[0]C[-15], ""u:mm"")),(FIND("":"",(TEXT(R[0]C[-15], ""u:mm"")))-1))"
- .Cells(iRow, 20) = "=RIGHT((TEXT(R[0]C[-16], ""u:mm"")),(FIND("":"",(TEXT(R[0]C[-16], ""u:mm"")))))"
- .Cells(iRow, 21) = "=LEFT((TEXT(R[0]C[-16], ""u:mm"")),(FIND("":"",(TEXT(R[0]C[-16], ""u:mm"")))-1))"
- .Cells(iRow, 22) = "=RIGHT((TEXT(R[0]C[-17], ""u:mm"")),(FIND("":"",(TEXT(R[0]C[-17], ""u:mm"")))))"
- .Cells(iRow, 23) = "=LEFT((TEXT(R[0]C[-17], ""u:mm"")),(FIND("":"",(TEXT(R[0]C[-17], ""u:mm"")))-1))"
- .Cells(iRow, 24) = "=RIGHT((TEXT(R[0]C[-18], ""u:mm"")),(FIND("":"",(TEXT(R[0]C[-18], ""u:mm"")))))"
- .Cells(iRow, 25) = "=LEFT((TEXT(R[0]C[-18], ""u:mm"")),(FIND("":"",(TEXT(R[0]C[-18], ""u:mm"")))-1))"
- .Cells(iRow, 26) = "=RIGHT((TEXT(R[0]C[-19], ""u:mm"")),(FIND("":"",(TEXT(R[0]C[-19], ""u:mm"")))))"
- .Cells(iRow, 27) = "=LEFT((TEXT(R[0]C[-19], ""u:mm"")),(FIND("":"",(TEXT(R[0]C[-19], ""u:mm"")))-1))"
- .Cells(iRow, 28) = "=RIGHT((TEXT(R[0]C[-20], ""u:mm"")),(FIND("":"",(TEXT(R[0]C[-20], ""u:mm"")))))"
- .Cells(iRow, 29) = "=RC[-10]+RC[-8]+RC[-6]+RC[-4]+RC[-2]+((RC[-9]+RC[-7]+RC[-5]+RC[-3]+RC[-1])/60)"

So now comes the tricky part: everytime I fill in my hours I also fill in the unique identifier that belongs to the project.

So I want to add an dropdown function and when I select YES I want the macro to get all the rows with the same unique identifier and calculate the total of hours and minutes spent on that number.

I understand this is a lot but the biggest problem is that I don't know where to begin... how do I get the cells from above into variabeles I can do some fun stuff with?

I'm lost

Greetings,

Fenna from the Netherlands xo