Adding diffrent values in a column

[JonniBravo]

Hi All,

I have been playing about with excel and trying keep track of the days I work and the hours I sould get paid as I am rather suspicious I am not always getting my full hours paid every month.

So what I have is my shift scheduel in an excel document with the dates. Below this I have a column, I want to add "1" when I have worked my full 12 hour shift as planned "2" when I have completed a 7.5h shift and "s" when I am sick.
Curruently I have the month of March running from rows b15 to al 15 and the month of April is b19 to al19, however to make it more complicated I want to calculate my hours betweenthe 10th of March and the 10th of April which is columns M15 to AL15 and G19 to P19.

Whats the best way of going about this??

[Pete_UK]

I think it would help if you attached a sample workbook - the FAQ describes how to.

Pete

[JonniBravo]

I think it would help if you attached a sample workbook - the FAQ describes how to.

Pete

Sorry about that herte is the spread sheet I have adapted for my needs although I am really struggling to get this to add my hours and then calculate my pay.