Hi
I wanted to compare two columns attached in sheet. But, dates have difference of 5H 30 min.
Executiontime=GC_Executiontimestamp+5h 30m |
Solved! Go to Solution.
Please use the below formula in Formula tool.
DateTimeFormat(Datetimeadd(Datetimeadd(Replace(Left([GC_Execution timestamp],19), "T", " "),5,"hours"),30,"minutes"),"%m/%d/%y %H:%M")
Many thankss
Shanker V
thank you for the reply, I'm comparing both columns but not getting expected result
Execution time in the sheet is different format in AM & PM, so retruning FALSE although correct
@joshikalyani One way of doing this
Thank you @binuacs , it worked