Timesheet different taking hours for different shifts from time sheet

**ryansweeney** · 02-10-2012, 05:04 PM

Hi Guys wondering if you could help me

i need to create a time sheet where by hours from 7 am to 18:00(6pm) get placed in one area and then hours after this get placed in another area to work out how many hours worked on on morning shift and then in the evening. as sometimes we only work 2 hours between 7-18 and then 8 after that your help would be greatly appreciatedTimeSheet.xls

**ryansweeney** · 02-16-2012, 10:40 PM

Bump anyone willing to help?

**JBeaucaire** · 02-17-2012, 02:43 AM

Didn't I give you formulas for this on another forum somewhere? Do you have the link to that so we have a starting point, at least?

**FDibbins** · 02-17-2012, 02:45 AM

If I understood yoyur request correctly, I think the attached SS has what you need. You were not too clear on what constituted "Night" hours, so I did not include anything for that.

Let me know if this is what you wanted, or if there is anything else I can add for you

**ryansweeney** · 02-17-2012, 04:06 AM

FDibbins thanks m8 thats exactly what i needed, yeah sorry i did not provide the times for night as i figured if i got what i need for evening i could modify it myself. i will work on it and if i can't get your help again. JBeaucaire i dont think so i posted on one forum of a related nature but was requested to start my own thread. thanks for the help though

**ryansweeney** · 02-17-2012, 04:26 AM

Hi FDibbins no i can't figure out how to get it to use past 00:00, The night shift would be from 00:00(midnight) untill 07:00 could you help me out one last time i think this is way beyond my basic programming ability. i will be eternally grateful

**FDibbins** · 02-17-2012, 08:15 PM

I have updated the formulas and streamlined them. I think it gives you wnat you want for all 3 categories. I made a table with range names to simplify the formulas, do not delete the table or the formylas will not work. You can either move it elsewhere, of hide the columns it is in.

Let me know if you need anything else

**ryansweeney** · 02-19-2012, 04:08 AM

you my friend are a legend thanks so much makes my life a million times easier

**ryansweeney** · 02-21-2012, 01:38 PM

Hey one more question i have found that i get some errors if i dont enter any time for 7 -18 00 so say i start at 21:30 and finish at 02:00 then it will not work? any ideas