schedule

[scott]

i am trying to amke an employee schedule on excel. i wat
it so that you enter the employee's in time on one cell
and enter the out time on an other. then i figured out a
formula to output how may hours the employee will work.
but i want to add up the hours a simple =sum() is not
adding up correctly.

EX:

A B C
in out hrs worked
10:00 AM 6:00 PM 8:00 =if(b1-a1>0,b1-a1,b1-a1+24) - -
8:00 PM 3:00 AM 7:00
12:00 PM 12:00 AM 12:00
12:00 PM 8:00 PM 8:00

11:00 -> excel saying total hours
=sum(c1:c4), should be 35:00 not 11:00
formula in col. C will caluate how many hours worked.
but when i try to add up all the employee hours it adds
up wrong.

any advise would be helpful

scott

 

[Frank Kabel]

Hi
just format your target cell with the custom format [hh]:mm to prevent
the rollover after 24 hours. You should also change your if function
(as you're currently adding 24 DAYS if B1<A1)
you may use
=(B1<A1)+B1-A1
instead