Forum Discussion
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 se...
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 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.
Not on a Mac. Trying to work through it now. great direction