Forum Discussion
Find the same time with different dates
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!
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]))
2 Replies
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]))