Here is a sample google sheet.
[url removed, login to view]
Please Make a script to do this
How it works.
1. Timestamp & Data fields are filled up already.
2. Data "A" have to be calculate like this.
1) row #2: first of A's Hours is 0
2) find next A
3) row #9: second A is calculated by first row of A and this row. formula is (row#2:Timestamp - row#9:Timestamp)*24. fill up Hours field
4) find next A
5) row #12: fill up Hours field with 0
6) find next A
7) row #13: same logic with 3: fill up hours field
8) stop to find at the end of A
3. Do same with "B", "C", "D"
4. row #6: if that data(In this sample "B" - one of A,B,C,D) is already is processed. stop to calculate
5. open Result Sheet
6. Write "A", "B", "C", "D" at any position
7. Write total hours by each data. (sum of Hours field by data)
8. this function have to work with custom button (add click button or menu)
7 freelancers are bidding on average $23 for this job
I read the instructions, I can do this. I have done this kind of work earlier but not with freelancer. If you are interested we can have a quick discussion now. Waiting your response - Thanks, Shailaja