Hi

Cell A1 & Cell B1 is having time format of 24hrs, h:mm,

I have put the data in A1 as 23.30 pm & in B1 1.30 am, difference between these two time is 2 hrs, .I have tried all the formula hour, time etc but didn't get the correct value.

Please suggest me the right formula to use here.

Thank you
Sunita