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.
got it (and just enabled power query) learning now. thx very much