Excel Help

[Darthshearer]

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?

 

[ST^]

Put a row below it with a formula

=MIN(A1, 7.5)

If A1 is less than 7.5, it'll give you A1, otherwise it'll give you 7.5

 

[Darthshearer]

Legend

Cheers marra