October 31, 2021
I'm having trouble getting GETPIVOTDATA to work with Time values.
First, pivot table doesn't recognize time values so I needed to convert them to general format in my data source and base my pivot table on that.
I have got 9 different time values starting from 08:00 to 16:00
08:00 doesnt work and 09:00 does work. I don't know why. Can you help me out?
I'm attaching a dummy template.
July 16, 2010
Welcome to our forum!
I think the problem you're having is caused by precision. The numeric equivalent of 8:00 is 0.3333333333' and for 16:00 it's .6666666666' and there are many more times that have this recurring value that also return errors when referenced with GETPIVOTDATA.
Instead of using GETPIVOTDATA, you can try referencing the PivotTable with INDEX & MATCH. You'll have to change the layout to Tabular and repeat the item row labels.
Alternatively, you can use SUMIFS to sum the data in the Raw Data Hourly table.
See file attached with INDEX & MATCH entered for Employee 1 and SUMIFS for Employee 2.