Forum Discussion

cris_22's avatar
cris_22
Brass Contributor
Apr 01, 2022
Solved

Total hrs for each date based on max and min

Hello.  I appreciate any help on this.  I need to get total hours in each day based on the max and min in each day.  I tried a pivot table but it won't summarize it by day.  for each day i need to see the min date stamp and max date stamp.  then with another column showing the total hours between these two dates.  should I be using a pivot table?  and then paste the results as values to calculate the total hours for each day?  i welcome any and all ideas to make this simple.

  • cris_22 Provided you're not on a Mac, Power Pivot could handle this. See attached! However I did change your raw data a bit in order to split the time stamp in a date (INT) and time (MOD,1) portion. Than you can summarize by day. See if you can get this to work in your own sheet. See attached.

3 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    cris_22 Provided you're not on a Mac, Power Pivot could handle this. See attached! However I did change your raw data a bit in order to split the time stamp in a date (INT) and time (MOD,1) portion. Than you can summarize by day. See if you can get this to work in your own sheet. See attached.

    • cris_22's avatar
      cris_22
      Brass Contributor
      got it (and just enabled power query) learning now. thx very much
    • cris_22's avatar
      cris_22
      Brass Contributor
      Not on a Mac. Trying to work through it now. great direction

Resources