Combine date + time & calculate the duration

[Anonymous]

Hi all,

I have 2 question regarding below data

1. May I know how do I combine date & time from different column ?

2. How can I calculate the duration of the time in minute?

Regards,

Nuha

[Vijay_A_Verma · Accepted solution]

Select your date columns and convert the column type to date. Do the same for time columns to convert them into time columns.

To combine after conversion

=[Date Column]&[Time Column]

However if don't want to convert the columns, use below formula

=Date.From([Date Column])&Time.From([Time Column])

If you want to convert Time into hours

=Number.From([Time Column])*24

If you hadn't converted column into Time, then

=Number.From(Time.From([Time Column]))*24

[Anonymous]

Hi @Vijay_A_Verma ,

Thanks! Done combine as below. 

How can I calculate the duration between end time to start time in MINUTE?

End Time - Start Time = how many MINUTE

Regards,

Nuha

[Vijay_A_Verma]

= Duration.TotalMinutes([End Time]-[Start Time])

[Anonymous]

Hi @Vijay_A_Verma ,

THANKS A LOT!!

Do you know what is wrong with my formulation below? Keep getting error

Regards,

Nuha

[Vijay_A_Verma]

if then will be

if [VGWTS]="ZN04" or [VGWTS]="ZN05" then.................