Forum Discussion
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...
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
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
thanks, solved