Getting Time Difference

[ranz_vincent]

Hello I need help please. I wanted to get the duration it takes from dispatch and arrival to store and my first problem is dispatch date and dispatch time are on seperate columns same with arrival to store and I cant combine them to a single column and from there my plan was to compute the duration from the 2 combined columns or  if anyone has a better way

[rajendraongole1 · Accepted solution]

Hi @ranz_vincent - You can create new columns to combine the dispatch date with dispatch time and arrival date with arrival time.

DispatchDateTime =
'Table'[dispatch_date] + 'Table'[dispatch_time]

Combine Arrival Date and Time

ArrivalDateTime =
'Table'[arrival_date] + 'Table'[arrival_time]

Once you have the DispatchDateTime and ArrivalDateTime columns, you can calculate the duration between them

Duration =
DATEDIFF('Table'[DispatchDateTime], 'Table'[ArrivalDateTime], MINUTE)

This formula calculates the duration in minutes. You can replace MINUTE with SECOND, HOUR, or DAY depending on your preferred unit of time.

Hope this helps.

[ranz_vincent]

Sorry I got side tracked from other tasks but thanks a lot for this i tried both suggestions and they worked great so thanks again.

[v-tangjie-msft · Accepted solution]

Hi @ranz_vincent ,

Thanks rajendraongole1 for the quick reply and solution. In addition to creating calculated columns in Desktop, you can also create new columns in Power query.

(1)Add column->merge column.

(2) Change column type.

(3) Add a custom column.

If you need minutes, use it:

Duration.TotalMinutes([arrival]-[dispatch])

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[ranz_vincent]

Sorry I got side tracked from other tasks but thanks a lot for this i tried both suggestions and they worked great so thanks again.

[rajendraongole1 · Accepted solution]

Hi @ranz_vincent - You can create new columns to combine the dispatch date with dispatch time and arrival date with arrival time.

DispatchDateTime =
'Table'[dispatch_date] + 'Table'[dispatch_time]

Combine Arrival Date and Time

ArrivalDateTime =
'Table'[arrival_date] + 'Table'[arrival_time]

Once you have the DispatchDateTime and ArrivalDateTime columns, you can calculate the duration between them

Duration =
DATEDIFF('Table'[DispatchDateTime], 'Table'[ArrivalDateTime], MINUTE)

This formula calculates the duration in minutes. You can replace MINUTE with SECOND, HOUR, or DAY depending on your preferred unit of time.

Hope this helps.