How to get total hours for each jobe code from the attached file using Pivot Table
Attached File : 838999 1167867 employee time.xls downloaded: 157 times
Menu
Pivot table doubt
Attached File : 838999 1167867 employee time.xls downloaded: 157 times
Replies (3)
you can do one thing
first open a new sheet copy each code column data in single column, below one by one do same for hours in next column, then apply pivot and take hours in data critarea,
Thanks for your reply. But this is what i am doing right now and it is taking some time as the excel files are that much huge when we take it for a year.
Find the Attached File for Your ready reference
Thanks
Recent Topics :
- GSTR1 amendment Bulk bills
- Capital Gain on Sale of Gold
- GST SALES RETURN MISSING 2025-26 FY
- Enquiry on FAST-DS system generated email
- Capital gain on sale of agriculture land
- Demand from TRACES
- FY 2025-26 ITC CLAIM DUE DATE
- 96084000 and 48202000 HSN code ka Tax Rate kya hai
- Clarifications for intra day transactions
- CA FINAL FR FINANCIAL INSTRUMENTS (Ind AS 109) Dou
Related Topics :
CAclubindia
