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)
Hello, I've already done the formula, and validated it against 300 rows of data. Formula works perfectly fine :) I'm not sure of how I could share the spreadsheet before you could accept my bid. But I think you cou Daha Fazla
Bu iş için 7 freelancer ortalamada $23 teklif veriyor
Hi, can help. Have done plenty of google doc scripts. Pls check screenshoot if this fit your hours number format or it must be rounded within 2 number after decimal point, ie smth like 1.30. [login to view URL] Daha Fazla
Hello, I am an excel and data entry expert. Contact me for more informations. Kind regards, Dragos !
Hi! I have 3 years of experience developing apps and solutions using the Google platform. I've gone through your project requirements and I know what needs to be done. I'd love the opportunity to work on your project Daha Fazla
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
hi, we have done a lots of project on Google script latest project we have completed is automatic sending emails to id in sheet based on data change.(something like mail chimp). we assure you if 100%accuracy and sa Daha Fazla
Dear, I can easily do this in 15 minutes. The most time will go to the preparation: I will have a couple of questions on how you want this working exactly. There are various ways to do this and the best solution wil Daha Fazla