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.

v-henryk-mstf's avatar
v-henryk-mstf
Community Support
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.