Forum Discussion

Casey Mims's avatar
Casey Mims
Copper Contributor
Oct 03, 2018

How to summarize time in/time out data to see employee hours worked

Hi all,   I have been given a rather large output file that I'd like help with summarizing. The file lists when an employee has clocked in and out of the building. I'd like to be able to summarize ...
Excel
Formulas and Functions
  • Casey Mims's avatar
    Casey Mims
    Copper Contributor
    Oct 04, 2018

    Thank you Lorenzo, I was able to make much progress with your help.

     

    Attached is an abbreviated version of what I have now. I'd like to be able to summarize the # hrs spent in the building per day. What is the best way to go about this? My actual file is quite long, and it's not conducive to simply sum specific cell ranges manually. Please help!

      • Casey Mims's avatar
        Casey Mims
        Copper Contributor
        Oct 05, 2018

        Thanks again Lorenzo!

         

        For the first column, is there an easier way to fill in the dates on each row besides manually? My actual file has >1000 rows, and there are 5 files. Yikes!

         

        Also, is there a way I can autofill the formula in Column E down the rows? When I autofill currently, it puts the sum on each row. I'd like the sum to only show up on the row where a new date first appears in Column A, like in your attached example.

         

         

Resources