Hey Dear community,
I need formula to count work time, i have very long list of login and logout time of workers, problem is login and logout times are in same column ( J:J ) and worker names are in B:B
right now i use minifs and maxifs formulas to find workers login and logout time , but i am sure there can be better way to do this. Can anybody help me please?
here is excel file http://alqoritm.com/table.xlsx
Most members are unwilling to access file-hosting sites. Rather, upload your file to this forum.
Having said that, time is just a number to excel, so you could probably just subtract "out" from "in"
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks