nconsistency in reports with Odata RRS feed

  • General discussion

  • Hello everyone,

    We have Project Online with Project Professional 2013. We use excel 2016 to download data set of projects and build reports, We use Odata protocol. The field Duration  in the report show the data different (a long number), and the duration in Project Professional show duration normal.  we use custom calendars (8,5 hours per day). See images below: 


    Anyone know why the values in the duration field are displayed this way. In other fields it eliminates the decimals as well.



    Friday, May 26, 2017 7:15 PM

All replies

  • Excel is getting the raw time and needs to be divided by seconds * minutes * 24 hours

    The ODATA has already done this for you can translated it for you in days.

    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Blog contains my field notes and SQL queries

    Wednesday, June 14, 2017 3:10 AM