Jump to content

MS Excel 2010 HELP>>>


Adam247

Recommended Posts

Hi Guys ,

 

trying to make a timesheet to keep record of what i am working but cant seam to find a formula that can automatically associate a set day for set hours eg monday to friday standard hours are 3.75 and sunday are 11.25 have managed to get the dates to change in accordance to the date on the time sheet but cant seam to associate the times to the same days e.g. monday 17:00 in 20:45 out

 

any help on this would be extreamly great as would save me a lot of hasstle trying to work out the hours i have worked each day and would stop me from getting confused. if you need to see the file i can send via email if any use thanks

HONOR IS DOING THE RIGHT THING, EVEN WHEN NOBODY IS LOOKING ...

Laugh and the world laughs with you; weep, and you weep alone.

"Yes, I will do the opposite. I used to sit here and do nothing and regret it for the rest of the day. So now i will do the opposite, and i will do something..." George Costanza

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

We and our partners use cookies on our website to give you the most relevant experience by remembering your preferences, repeat visits and to show you personalised advertisements. By clicking “I Agree”, you consent to the use of ALL the cookies. However, you may visit Cookie Settings to provide a controlled consent.