Find the same time with different dates

[Anonymous]

Hi,

In the below file, I'm trying to find when two times match when they have different dates. I have tried to separate the times from the dates as you can see below (Actual Cut Off Time and Cut Off Time are formatted as just Time) and done an If formula for seeing when these match, but as you can see on the fifth row this isn't working. I'm assuming it's because dates are still attached in the background - can I separate them?

Thanks!

[AnthonyTilley · Accepted solution]

just extract the time as a calculated colunm

you will get a datetime colunm where the date is always the 31/12/1899 followed by the time 

this can tehn be formated to time only and will calculate correctly 

time = time(hour('Table'[DATETIME]),MINUTE('Table'[DATETIME]),SECOND('Table'[DATETIME]))

[Anonymous]

Thank you!