On Sunday, December 23, 2012 3:51:47 PM UTC+3, Spencer101 wrote:
FEVOOO;1608199 Wrote:

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.



Try this in C2:



*=IF(B2<A2,(B2+1)-A2,B2-A2)*









--

Spencer101

yeeeees, I was tring all the night fo IF formula appreciate