Forum Discussion

WillemUK's avatar
WillemUK
Frequent Visitor
8 years ago
Solved

If condition between two times

I am trying to use an if statement to determine type of wastage created between two tim frames.   The idea is that between 14:30 and midnight the wastage is labelled as "End of Day Wastage" and the...
  • WillemUK's avatar
    WillemUK
    8 years ago

    No worries i solved it.

     

    The automatic cutoff time was 59:59:59 so at 00:00:00 the calculation returned back to "Wasted".

     

    I removed the AND() and Time(Hour(Wastage[Transaction Date]),minute(Wastage[Transaction Date]),SECOND(Wastage[Transaction Date])) <= Time(00,00,00)) from the formula.

     

    Here is the working code:

    Wastage Type = IF(Time(Hour(Wastage[Transaction Date]),minute(Wastage[Transaction Date]),SECOND(Wastage[Transaction Date])) > Time(16,30,00), "End of Day Wastage", "Wastage")

WillemUK's avatar
WillemUK
Frequent Visitor
8 years ago

No worries i solved it.

 

The automatic cutoff time was 59:59:59 so at 00:00:00 the calculation returned back to "Wasted".

 

I removed the AND() and Time(Hour(Wastage[Transaction Date]),minute(Wastage[Transaction Date]),SECOND(Wastage[Transaction Date])) <= Time(00,00,00)) from the formula.

 

Here is the working code:

Wastage Type = IF(Time(Hour(Wastage[Transaction Date]),minute(Wastage[Transaction Date]),SECOND(Wastage[Transaction Date])) > Time(16,30,00), "End of Day Wastage", "Wastage")

  • euiane's avatar
    euiane
    New Member
    4 years ago

    Hello! 

     

    I also want to have a formula for below condition:

    If time is within 06:01 AM to 20:30PM, it will display as "Beyond the shift". Can you help me?