I have weekly time sheets out of our quickbooks pos system (raw files attached). What I need is to combine the 2 weeks into one total time for the bookkeeper. I would like this in some macro form so it looks in both files (or I could put them in one sheet) and it looks up the Login Name and finds all total hours for that login name. It should be obvious that I need the time to stay as time not turn into a number so that the minutes get added correctly. I also need a column to be able to enter time manually if they did work away from the office.
7 freelancer bu iş için ortalamada 104$ teklif veriyor
I am looking for long term . Let me know what is the work and how long it will be there. I am open to work on longer projects. bid will be negotiable
I have been working on excel with basic and advance knowledge in Excel. On my current company we always work with excel. I love to make life easier by using formula's and macros.