On Sunday, December 23, 2012 11:37:22 AM UTC+3, joeu2004 wrote:
"FEVOOO" wrote:

I HAVE EXCEL SHEET TO CALCULATE TIME FOR WORKING HOURS

[....]

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.



First, the format of the cell does not matter.



Second, to avoid the problem with computing negative time, use the following

formula:



=B2-A2+(A2B2)



formatted as Time or whatever you want.

Thank you so muuuuuch, its working perfectly :)