Hi everyone




i need some help with my worksheet, ive scoured many youtube videos and other sites to help but to no avail. i have attached my worksheet for people to take a look at to try and get a grasp of what im on about.


i need some formulas to work out time worked and it needs to incorperate overtime and if someone has a sick day, holiday or just a day off. i need this to be one formula, i also have a section that need to calc working day eg 13 or 15 so if someone works >=13hrs then the box needs to show 13hrs and if 13hrs and 01min it need to show 15. also i need a warning of some sort either by changing the cell colour to red or have pop up to day that if they use a 15hr then they have 2 more 15's left and if they use another the needs to say 1 more left and if last one is used then zero left. this need to calc per weeks. similarly for the driving hours. a driver may extend only twice per week.

oh and when holiday is entered it only pays 8 hours. all info is entered on the userform.

could someone help as im getting desperate now.


many thanks
Paul

Attached Files

working progress.xlsm (130.7 KB, 13 views)

Hi

quite a large project you require. There are lots of similar solutions on the net. Google around a bit, free solutions enough.
Also your example is a xlsm file. Do you need a VBA answer ?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Yeah, Paul, I'm with Pecoflyer; this is a lot to pile into one formula. It may be possible (except for coloring the cell; that'll probably take conditional formatting), but even if it is you may be better off doing it with multiple "helping columns".

My recommendation is that you start with Pecoflyer's question, because we need to know whether you want to do this with or without VBA; the answers will differ depending on that. And second, that you tackle this a piece at a time. Start with a simple work-hours calculation. Then add in overtime. Then try to figure out how to handle vacations and holidays. And so on, one piece at a time.

I would love some VBA help if you could help that would be great.

thank you

i have been hunting around for a while.

ive been trying to workout how to do formula based on words and not numbers but ive not come across any.

Cross post http://www.excelguru.ca/forums/showt...ted=1#post8595
Please read my signature

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

WARNING: I just tried to open your sample .xlsm, flyinghigher, and my copy of Excel claims that what it found there isn't actually an .xlsm format. I didn't open it, of course, but it sounds like it's corrupted.