Problem with adding IF statement

[YcnanPowerBI]

Hello. I am pretty new here so please forgive me if I post in the wrong place, etc. But onto my issue. I have a calculated column that assigns a time interval to each row. I now need it to look at another column if the original column is blank....and I can't seem to get it working. This is edad I have in my original calculated column 

= Table.AddColumn(#"Changed Type", "Custom", each Time.From(Text.From(Time.Hour(Time.From([paidTime])))&":"&(if Time.Minute(Time.From([paidTime]))>= 30 then "30" else "0")&":00"))

any help would be greatly greatly appreciated. Thank you. 

[rubayatyasmin · Accepted solution]

Hi, @YcnanPowerBI 

Try this updated code,

= Table.AddColumn(#"Changed Type", "Custom", each 
    let 
        actualTime = if [paidTime] = "" then [otherTime] else [paidTime]
    in 
        Time.From(Text.From(Time.Hour(Time.From(actualTime)))&":"&(if Time.Minute(Time.From(actualTime)) >= 30 then "30" else "0")&":00")
)

[YcnanPowerBI]

It worked, thank you so much!