Calculating difference between start and end time

[jessika2105]

Hi. I have checked on Internet. If I enter 8:00 pm in start time (cell A2)and enter 8:00 am in End time. (Cell B2). To calculate the difference, I have inserted the formula = (b2-a2)*24 I have then converted the formating to General to have the number of hours. However why I am getting -12
Second question from 8:00 pm to 8:00 am, I should get 11 hours, but I'm getting -13
Kindly help me

 

[Flaiban]

Try this formula :
=IF(end>start, end-start, 1-start+end)
example : =IF(B2>A2;B2-A2;1-A2+B2)

To see the result in hours and minutes, apply a time number format like this: hh:mm

 

[AhoyNC]

Another option.
Format cell as [h]:mm

Book2
	A	B	C
1
2	8:00 PM	8:00 AM	12:00
Sheet1

Cell Formulas
Range	Formula
C2	C2	=MOD(B2-A2,1)