Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Time Delta

I am creating a time & motion study and want to compare the actual time 'turning spanners' compared to other unproductive tasks.   I have created a time log database of all tasks in the working day...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Anonymous ,

     

    According to the information you describe, you can add a judgment condition to the original formula. I did a test, the reference is as follows:

    Col_ = 
IF (
    HOUR ( 'Table'[End Time] ) = 10
        && MINUTE ( 'Table'[End Time] ) <= 0,
    TRUE (),
    IF ( HOUR ( 'Table'[End Time] ) < 10, TRUE (), FALSE () )
)

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin's avatar
lbendlin
Super User
4 years ago

Sounds good. What have you tried and where are you stuck?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi,

     

    Thanks for your response. I have tried creating a custom column to generate a true of false column using the below DAX

     

    7AM-10am = IF(HOUR(dilo_master[end_time]) >= 7 && HOUR(dilo_master[end_time]) <= 10.00 ,TRUE(),FALSE())
     
    This works how ever instead of cutting off at 10:00am as required it is pulling end times all the way up to 10:59am. Any ideas how to get around this?
     
    Many thanks,
     
    Elliot 
    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      Two options. Either remove the equal sign

       

      7AM-10am = HOUR(dilo_master[end_time]) >= 7 && HOUR(dilo_master[end_time]) < 10.00

       

      or  consider the minutes as well

       

      7AM-10am = HOUR(dilo_master[end_time]) >= 7 && HOUR(dilo_master[end_time])*60+MINUTE(dilo_master[end_time]) <= 600.00