Forum Discussion
Combine date + time & calculate the duration
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? Rega...
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
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
Most Valuable Professional
Most Valuable Professionalif then will be
if [VGWTS]="ZN04" or [VGWTS]="ZN05" then.................