Using Excel as a scheduling application

[Jennifer S]

I want to use Excel to create and post my employee's schedule and tally up their scheduled hours for the week.
When my managers create the schedule, they would use 6-CL as representing 6pm to close (2am) that equals 8 hours for a shift.

How can I get Excel to calculate that into the total hours worked in the last column? Is there a way to have Excel remember that whenever 6-CL is typed in a cell, it needs to have a value of 8?

I hope this is simple enough to answer that I would be able to get a response soon. Thanks.

[Lifesigns]

Hi,

I really depends on the setup you have but a simple IF statement could do the trick:

=If(A1="6-CL",8,A1)

Assuming the entries start in A1, this formula could be in B1 which means Column B will only have numbers which you can total.

[teylyn]

Hello,

that's not much to go by. If the text 6-CL is entered in A1, this formula will return the number 8, otherwise the content of A1 is returned:

=if(A1="6-CL",8,A1)

I guess it will be more complex than that, so you may want to post a little data sample in a worksheet.

cheers,