That is indeed what I meant, I was thinking too hard that I couldn't figure it out. thank you very much! I learned from your help!
I try to make a clocking sheet, with time in and time out.
It's almost working only I get the date and time in one cell and the date like mm-dd-yy.
I like to split the time and date both to a cell date in C and time in D
And by clocking in and by clocking out date to E and time to F
The date I prefer to righten like dd-mm-yy.
But I don't know how to it, does some one know and will help me?
Thank you Very much, the formula works! I really appreciate your help!
Dear expert, To better monitor a work process I'm looking get a right formula. I try already a few weeks to create a formula that count a range of times in column B but selected by year witch is noted in column A by a date. so that I can see per year how much time is spent on certain activities. Unfortunately I am unable to formulate the correct formula.
I have a date in column A.
In column B the time
In columns E3 and E4 I would like to see the result of the hours spent per year.
Can someone give me some advice on how I can best achieve this?
please see the attachment for a example
I make a little mistake by translating the file to English,
Thank you for your fast replay, I'm very happy with your help!
I have look to your file and try the with this codes to solve my problem but unfortunately I have still some trouble to solve it and understand whats happening. I look-over the internet and this form but unfortunately I didn't find a answer.
I will try to explain what I try to reach,
I like to make a order request document and work with a other colleague togther.
1) I create to userforms in the "Order request doc"one for a new request the data will fill in and after save the data will be save on a new row, and create a new order number in the "database doc"
2) In the second userform "Order request doc" my colleague can ask the same order again and save it on a new row, by the same order number "database doc"
2.1) in the second my colleague ask the same order number but adapt the request and save it on new row where the same order number with a new version number created "database doc"
I create a listbox in my userform "Order request doc" and I see the value of the database orders in my userform, when I select a row in my listbox the data will automatically fill in the textboxes, this is working perfrct.
Because there will be more than 4000 rows filled, I prefer a search option in my listbox, I prefer to fill in the textbox and the search automatically to the database in column A to the right number and fill in the data after select the row in my listbox.
Now my problem, when search in "Order request doc" in userform same order for example to order number 7 of order number 20.7.2 the listbox is losing his columns structure.
I am quit new white VBA but create a userform database, I like to serach records in my database. therefor I created a searsch txt box, in combination with a listbox.
When I open my userform the data in my listbox are clearly there, but when I try to search to data, the value in de listbox are mixedup. I try alost a week to find the problem but I can't find it.
does some one know how to solve this, and will help me?
please see attachment