Forum Discussion

bjorneev's avatar
bjorneev
Advocate I
5 years ago
Solved

Pagniated Report Excel Export formatting problem

Hi all,

 

I have created a report in Power BI report builder that contains some date and time information. The first rows of the table looks like this when I run the report:

When I export this to excel I get the following corresponding values: 

The hash values reprents a number between -1 and 0, and excel can't interpret them as time due to the negative sign. If I change the sign or add +1 one the "Inicio"-column value I get:

+1 gives the correct time value. There is a formatting issue between report builder and excel I can't seem to figure out. I found a post where someone said to enable the "Use 1904 date system" under excel options. If I do that I get the following:
  

The dates are changed and the times are "mirrored". It is important for my delivery that the format is correct without manually fixing cells in the excel after each export. 

Anyone tips on how to fix this? Thanks!

  • bjorneev , This just one idea, may not be ideal

     

    Format time  = format([Start Time],"HH:MM:SS")

    This will make it text and will not change format

2 Replies

  • bjorneev , This just one idea, may not be ideal

     

    Format time  = format([Start Time],"HH:MM:SS")

    This will make it text and will not change format

    • bjorneev's avatar
      bjorneev
      Advocate I

      =Format(Fields!Time_From.Value,"HH:mm:ss")

      Worked like a charm! Thanks amitchandak  🙂