Search results

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

Luke Funny you should mention this I had thought of including this in the last set of examples, the problem being you enter the bonus period twice? These shifts would be a rare occurrence but not impossible although they would be restricted to weekend days Saturday, Sunday and Holidays. If we...

Hi Luke Sorry for the previous confusion on cells I tried out the formula and it works for almost every start/finish except for examples as follows Start date 17/10/11 time 16:00, Finish date 17/10/11 time 22:00, this input displays ###### but should be 00:00 i.e. start /finish times not in...

Hi Narayan Just checked over your data there are a couple of errors as follows - Lines with first two test times of 21:00 column L Bonus 2 Time should be 2:00 on both lines rather than 3:00,first line with test time 23:00 column L Bonus Time 2 should be 0:00 rather than 3:00 Thanks for taking...

Hi Luke Just noticed that in your formula you are using AJ3 and AH3 which both have the same value i.e. 23:00, AH3 is the finish time for the bonus1 period (23:00) and AJ3 is the start time for the bonus2 period (23:00)the bonus period I am having problems with. The finish time for the bonus2...

Hi Luke The formula does not work for every start/finish scenario that I have tried some examples as follows - Start date 16/10/11 time 23:30, Finish date 17/10/11 time 07:00, this input displays 07:30 as bonus hours but should be only 6:30 as bonus time runs from 23:00 to 06:00. Also if...

Luke - I tried your formula but it does not seem to work. I will try to give you some clearer information as follows. A person can start and finish a shift at any time, they receive a bonus additional to their pay of 25% of the hourly rate for the number of hours worked if they work between the...

Hi and thankyou to all in advance. The problem is as follows, I have been working on time sheet to calc pay. Example 1 - If a person starts shift on 15/10/11 at 17:00 and works to 15/10/11 23:00 then the time he works falls in to a bonus period 20:00 to 23:00 i.e. he has worked 6hrs and 3 hrs...