Recent content by Sam Patterson

Hi All Sorry I have not got back to you sooner but have been in bed with a bad cold. I have since discovered that letting the spreadsheet run for a while on the PC will allow the values from 28th January to April (i.e.left to right on the screen)to be displayed on mouse roll over. I do not...

All Thanks I will read the discussion and check out the file Will let you know how i get on asap

Hi and thank you in advance I have created a column chart displaying two sets of information. The Value axis is labelled tonnes and shows amount in tonnes and the category axis is labelled months and target and shows the amount in stock for each week of each month and also a comparison stock...

Hi Narayan The worksheet seems to work fine and I can add new times as required. Thanks for all your effort on this, it is very much appreciated. I have a bit more to do to the sheet before it can calculate the salaries for the Overtime but that should be easy enough I am hoping If I come...

Hi Narayan As before cannot download this until I get home, will be a while before I see your worksheet and verify. Thanks in the meantime Sam

Hi Narayan Link for uploaded file below copy and paste into your browser and click on download file https://rapidshare.com/files/4269291604/Overtime.xls Sam

Hi Narayan Security policy at work does not allow uploads it will be at least 9hrs before I can do this from home. I have never used Name Manager before so will have to check this out. The worksheet I am using is the one you uploaded, with the bonus2 formula modified as per your post and then...

Narayan Just looking at your spreadsheet, can you explain to me how cell E1 (=Bonus_2_Start)finds the data in cell C2. The reason I was asking was I was going to put a Bonus1 Start and End , Bonus 2 Start and End, Start of new Day and Midnight cells on each row and use them for each seperate...

Hi Narayan You're right, sorry I changed the dates on the last line so it did not work. Anyway thanks for all your effort and work I will see if I can modify the way data is recorded and use your formulas for the spreadsheet. If it does not work out I may have to try the macro (not much...

Hi Narayan I have tried it with a number of different starts and finish times and it seems to work fine. I changed the Start Date to 20/10/11 and End Date to 21/10/11 and it did not work as I thought it might not. Is there any way not to keep changing the start and finish bonus dates every time...

Thanks Narayan I will try this out and let you know how I get on Sam

Hi Narayan The time from 03:00 to 06:00 is treated as bonus2 time and the time from 06:00 to 09:00 will be treated as normal time. Sam Jean I believe your formula is for the other post

Hi Narayan I believe I understand the logic behind what you are saying, is there any way forward without having to split the days? Sam Jeanbar thanks for the information I do understand the logic after reading it a few times Thanks Sam

Hi and thanks for all the hard work Jeanbar allow me a little time to try to understand your comments and I will let you know how I get on Narayan I downloaded your worksheet and checked through it and it seems to be fine except for the following exceptions - if you take the last line and...

Hi Narayan Will attemp to try this out over the weekend, but am not sure if my skills are up to it. If you get a chance would you also give it a go. Thanks again enjoy your rest Sam