Forum Discussion

martijnth's avatar
martijnth
Icon for Helper II rankHelper II
7 years ago
Solved

Strange / Wrong DateDiff results

Dear Reader, I/m facing some difficulties with Datediff. Please see below. This is part of querri where I'm substracting two dates. So here the result should be something like 11.xx minutes. For mos...
Need Help
Show and Tell
Tips and Tricks
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, martijnth

    It seems that [time produced] is a date-time column then you just change the format of it.

    So you need to use this way as below:

    Use TIME Function to add a new time column as below:

    Time1 = TIME(HOUR(Table1[time produced]),MINUTE(Table1[time produced]),SECOND(Table1[time produced]))

    Result:

     

    Best Regards,

    Lin

     

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, martijnth

It seems that [time produced] is a date-time column then you just change the format of it.

So you need to use this way as below:

Use TIME Function to add a new time column as below:

Time1 = TIME(HOUR(Table1[time produced]),MINUTE(Table1[time produced]),SECOND(Table1[time produced]))

Result:

 

Best Regards,

Lin

 

 

martijnth's avatar
martijnth
Icon for Helper II rankHelper II
7 years ago

thanks, solved