Forum Discussion
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_EekelenPlatinum 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.