none
Calculating time RRS feed

  • Question

  • ION GEW LEVTYDVA

    type is Time 

    The formula below does not work. If ION GEW LEVTYDVA equals 00:00:00 I want the result in the added column to be 0 

    Apparently this is not correct. How can I solve this. Thanks for your reply.

    #"Added Custom5" = Table.AddColumn(#"Added Custom4", "LevertijdCorrect", each if [ION GEW LEVTYDVA] = TIME(0 ,0 ,0) then 0 else if [VroegsteLevertijd]<= [ION WRK LEVTYD] and [LaatsteLevertijd] >=[ION WRK LEVTYD] then 0 else 1),


    • Edited by PeterConw Friday, March 27, 2020 4:47 PM
    Friday, March 27, 2020 3:37 PM

Answers

All replies