Time Calculation in Excel

Question

I AM WORKING MIDNIGHT(24:00) TO NEXT MIDNIGHT (00:00) IT SHOULD BE 24:00 HOURSA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CSTART TIME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;END TIME&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TOTAL HRS00:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;24:00&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;***&nbsp;here if I am putting formula say&nbsp;=IF(A2&gt;B2,1+B2,B2)-A2&nbsp;&nbsp;it is showing 00:00. it should be 24:00 hrs. please help me out

sergeibaklan · Answer

You may apply&nbsp;[hh]:mm format to C2

Forum Discussion

Time Calculation in Excel

Share

Resources