Forum Discussion

Will90's avatar
Will90
Frequent Visitor
7 years ago
Solved

Difference between 2 times

Hi,

I have 3 columns in Excel > Start, Finish and Difference

When I import the excel i get errors with the times in Power BI.

What I want to do is list all differences that exceeds 4 hours.

 

Example:

Start - Finish - Difference

15:00 - 17:00 - 02:00

15:00 - 17:30 - 02:30

16:00 - 20:05 - 04:05

17:00 - 23:00 - 06:00

 

 

So, how do I import the excel spreadsheet without getting errors? I guess I can just filter the min of "Difference" column to show only greater than 04:00 hours?

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Will90,

    See these images. (My Excel is setting in Spanish, sorry)

    You always have to change houre format in PBI

     

    Tell us your results.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Will90,

    See these images. (My Excel is setting in Spanish, sorry)

    You always have to change houre format in PBI

     

    Tell us your results.