Convert Date time

[joshikalyani]

Hi

I wanted to compare two columns attached in sheet. But, dates have difference of 5H 30 min.

Executiontime=GC_Executiontimestamp+5h 30m 

[ShankerV]

Hi @joshikalyani 

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

[joshikalyani]

thank you for the reply, I'm comparing both columns but not getting expected result

[joshikalyani]

 Execution time in the sheet is different format in AM & PM, so retruning FALSE although correct

[binuacs · Accepted solution]

@joshikalyani One way of doing this

[joshikalyani]

Thank you @binuacs , it worked