I HAVE EXCEL SHEET TO CALCULATE TIME FOR WORKING HOURS, USEING FROM TO AND TOTAL TIME AS FOLLOWING:
FROM (A2), TO (B2) , TOTAL (C2)
SHIFT HOURS FROM 06:00AM TO NEXT DAY 06:00AM AS 24HRS FORMAT CELL
THE PROBLEM IS AFTER PASSING 24:00 MIDNIGHT (FROM 01:00AM TO 06:00AM) TOTAL IS NOT SHOWING BECAUSE ITS LESS THAN 24.
PLEASE HELP.