Forum Discussion

RvdHeijden's avatar
RvdHeijden
Icon for Post Prodigy rankPost Prodigy
8 years ago
Solved

Calculate time bigger then ...

I have a simple question at least i hope so.   I have a table with a column in it called 'Technisch gereed' which has data/time values for example "13-11-2017 13:00:00" or "7-11-2017 20:57:00"   ...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    8 years ago

    Zubair_Muhammad just a small remark: a formula like if condition then true else false can be shortened to just condition.

     

    Applied to your formula:

     

    Column =
    TIME ( HOUR ( TableName[Technisch Gereed] ), MINUTE ( TableName[Technisch Gereed] ), SECOND ( TableName[Technisch Gereed] ) )
        > TIME ( 16, 30, 0 )
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi RvdHeijden

 

Do you simply need True or False in the Column?

 

Column =
IF (
    TIME ( HOUR ( TableName[Technisch Gereed] ), MINUTE ( TableName[Technisch Gereed] ), SECOND ( TableName[Technisch Gereed] ) )
        > TIME ( 16, 30, 0 ),
    TRUE (),
    FALSE ()
)
MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
8 years ago

Zubair_Muhammad just a small remark: a formula like if condition then true else false can be shortened to just condition.

 

Applied to your formula:

 

Column =
    TIME ( HOUR ( TableName[Technisch Gereed] ), MINUTE ( TableName[Technisch Gereed] ), SECOND ( TableName[Technisch Gereed] ) )
        > TIME ( 16, 30, 0 )