Jump to content

Excel Help


Recommended Posts

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

  • 2 weeks later...

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 have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.