TIME CALCULATION

  • Thread starter Thread starter FEVOOO
  • Start date Start date
F

FEVOOO

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.
 
FEVOOO said:
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.
Click to expand...

First, the format of the cell does not matter.

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

=B2-A2+(A2>B2)

formatted as Time or whatever you want.
 
FEVOOO said:
I HAVE EXCEL SHEET TO CALCULATE TIME FOR WORKING HOURS
[....]

FROM (A2), TO (B2) , TOTAL (C2)
Click to expand...
SHIFT HOURS FROM 06:00AM TO NEXT DAY 06:00AM AS 24HRS
Click to expand...
FORMAT CELL THE PROBLEM IS AFTER PASSING 24:00 MIDNIGHT
Click to expand...
(FROM 01:00AM TO 06:00AM) TOTAL IS NOT SHOWING BECAUSE
Click to expand...
ITS LESS THAN 24.
Click to expand...



First, the format of the cell does not matter.



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

formula:



=B2-A2+(A2>B2)



formatted as Time or whatever you want.
Click to expand...

Thank you so muuuuuch, its working perfectly :)
 
Back
Top