Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to extract date. How to extract and calculate the time difference to display in a KPI
Hi,
Are you looking for following
LOAD [Start Date] as StartDate,
StopDate,
(Floor(StopDate) - Floor([Start Date])) + (
(Ceil(StopDate, 0.00001) - Floor(StopDate)) -
(Ceil([Start Date], 0.00001) - Floor([Start Date]))) as TimeDelta
FROM
[..\Data\Time1.xlsx]
(ooxml, embedded labels, table is Sheet1);
Expression
interval(TimeDelta, 'hh:mm')
Hi Santhoh,
You may try this
If you prefer in load script:
Interval([StopDate]-[Start Date],'hh:mm:ss') AS [Time Difference]
If you prefer in expression:
Interval([StopDate]-[Start Date],'hh:mm:ss')
Sokkorn
Thank you. I appreciate you for the time & solution.
Thank you for the solution. It works fine.