employee scheduling

[Guest]

Does anyone know a formula to add the number of hours worked each day
using a format of #am-#pm or #am-#am or #pm-#pm.
I am making a weekly schedule for 15-20 employees. I have across the
columns days and dates of the week. Down the rows I have first the area to
be worked and then the emplyees names. In the coresponding date/day and
employee name I am putting just the time they are to be in that area
(6am-2pm).
At the end of each week and the end of each area worked I need to put
the total hours for each employee and for that specific area. After I have
added (on paper or in my head) the hours worked for the week for each
employee I enter that at the end of each of their rows.
I have the formulas for adding each employees hours and gettin a total
for each area and I have a formula for adding all areas together to get a
total for all areas. What I don' have is the formula for adding the hours
worked each day for each employee. I would like to try and keep the format I
have right now (7am-3pm) that I have right now. Is there anyone who can give
me the right formula for this.

 

[Bob Phillips]

Phil,

I think this works, but beware it assumes the data in absolutely correct
format.

=IF(RIGHT(A1,2)="am",MID(A1,FIND("-",A1)+1,LEN(A1)-FIND("-",A1)-2)-LEFT(A1,F
IND("am",A1)-1),MID(A1,FIND("-",A1)+1,LEN(A1)-FIND("-",A1)-2)+12-LEFT(A1,FIN
D("am",A1)-1))

--

HTH

RP
(remove nothere from the email address if mailing direct)