wykikitoon 20420 Posted July 28, 2010 Share Posted July 28, 2010 One for you Excel Bods I am trying to keep track of time I am working on a certain project so I have set up an Excel Spreadsheet. Accross the top I have the days of the week and beneath that I shall put time against it. Which of course I can total. Now, the tricky (for moi) part. I can only book 7.5 hours a day to it. yet, I am doing more. Soooooo. If I say put 10h in, how can I make it stop at a maximum of 7.5? also, is there a way of adding both totals up?I.e if I do five 10 hour days its a total of 50 hours actual but only 37.5 hours to book to? Hope this makes sense? Link to comment Share on other sites More sharing options...
wykikitoon 20420 Posted July 28, 2010 Author Share Posted July 28, 2010 Done Added =MIN(A1, 7.5) Link to comment Share on other sites More sharing options...
Happy Face 29 Posted August 6, 2010 Share Posted August 6, 2010 No wonder you need to do so much overtime if this is what you spend time on when you're supposed to be working Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now