Time Calculation in Excel

[Chandan Singh]

I AM WORKING MIDNIGHT(24:00) TO NEXT MIDNIGHT (00:00) IT SHOULD BE 24:00 HOURS

A                                  B                               C

START TIME               END TIME                TOTAL HRS

00:00                           24:00                       *** here if I am putting formula say =IF(A2>B2,1+B2,B2)-A2  it is showing 00:00. it should be 24:00 hrs. please help me out

[#2]

You may apply [hh]:mm format to C2