How to calculate two different timestamp ?

[Anonymous]

Hi all,

In the following image i would like to calculate the variance of ExaminationEndTime and ExaminationStartTime.

the output must be a integer or a whole number in minutes. so for example :

The variance of these two columns on the first row must be 5.

Any suggestions?

Many thanks,

Rega

[Eric_Zhang]

@Anonymous

You could try 

diff mins =
IF (
    HOUR ( 'Table'[ExaminationEndTime] ) <= HOUR ( 'Table'[ExaminationStartTime] ),
    DATEDIFF (
        'Table'[ExaminationStartTime],
        'Table'[ExaminationEndTime] + 1,
        MINUTE
    ),
    DATEDIFF ( 'Table'[ExaminationEndTime], 'Table'[ExaminationStartTime], MINUTE )
)

[Anonymous]

Hi @Eric_Zhang,

Thanks for your input but i got the following message:

The start date cannot be greater than the end date...

[Anonymous]

Hi @Anonymous,

Try to use this calculated column:

Column = ([ExaminationEndTime]-[ExaminationStartTime])*24*60 

 // in minutes

If not works, try to change the columns to Date/Hour, and check which date you have in both columns.