Extract Date from Time & Calculate the time difference

[santho_ak]

Hi,

    I need to extract date. How to extract and calculate the time difference to display in a KPI

[vvira1316]

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')

[Sokkorn]

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

[santho_ak]

Thank you. I appreciate you for the time & solution.

[santho_ak]

Thank you for the solution. It works fine.