Thank you for your very informative and professional video series. Although I have been an Excel user for may years, I am learning a little more with every video.
I have a spreadsheet that lists fractional hours in decimal form. When I attempt to use the data in a pivot table, the pivot table converts the decimal to a whole number. All cells with less than 1 hour are rounded up and displayed in the pivot table as 1. Is the pivot table function unable to understand how to transfer and sum the decimal?
I suspect I may have to add an equation to the original data column to convert the decimal prior to converting the data range to a table for use with the pivot table function.