adjust formulas to return correct value to Gross Profit & bankroll column

Hi, need help adjust formula to give correct amounts to Gross Profit column and Bankroll from when adding Bounty amt.
in cell s23 you can see amt. of 150 to re-adjust gross & bankroll.
I re-upload file as i fixed the category column to read the name.

To add the bounty to the Gross Profit change the formula in the Gross Profit column to read:

Formula:

Please Login or Register  to view this content.

No changes should be needed to the formula in the Bankroll column.

Test and you will see that getting rid of the amount in cell V14 will cause the rest of the Bankroll column to display incorrect results.

thank you, yes i see numbers change. would that require vba then? can we get the column K formula adjusted?
i would like to set up the way it play out that night. if you see row 16 i and Gordo agree to who ever win would returned 5% if i win or him.
which in this case i won 1st for 3500 so gave him a 5% of the amt. won of 3500 can we add that to the formula i add the 5% in column G16 but he didn't give me any money

The file opens to the Tournament sheet. Column K on the Tournament sheet is Date. I don't know what needs to be changed.
The name Gordo appears in the Player column in row 17 and 5% in cell G16 but beyond that I don't what needs to be done.

Would the same thing hold true for the rows with Lee in the player column?
If that is the case, then should the cost + fee be zero?
If so then you could populate the cost + fee column using: =IF([@Player]<>"",0,[@[Sold % ]]*[@[%*MU]])

thank you.
Lee i only lend 200 dollars no agreement of % i will dedetely the money borrow only have games just wante to see everything that happen that night. will test formula above.
yes cost plus fee should be 0 since he didn't give me anything for buy-in
how can the value! in p7 be corrected?

Paste the following into cell P7 and copy down:

Formula:

Please Login or Register  to view this content.

can you help adjust columns B,C,D
1.B column would like to type date as 1/6/24 to then show as is January 6 can't it not repeat the # like 13 & 19 when i play 2 times different casino or same.
2. C & D column just would like to type the time tounament starts 3:21 and ends 15:37
if it can show the correct day would be great as is showing wrong (Sat) for all. Note: end time 0:00 i don't have a time only for re-entry using receipt time
time i will force myself to only re-enter 1 no more. and keep time when bust out.
3. can you please right duration formula too
and last delte column M

1. It looks like you are just entering the first playing date of a month and then after that a number that should stand for the day of the month. Excel is not going to understand that.
2&3. Most of the entries in columns C:D are text which make it hard for Excel to calculate duration.
Perhaps this what is in the file would work in google, don't know enough to say, but for Excel you would need to type in the start date and time and the end date and time and then use formulas to populate the Date column and the Duration column.
The formula in column M could then be used to populate the Date column.

To show only the time custom format the start and end time columns using: h:mm;@
In order to get rid of the blue arrows type the end times as shown in row 7.
The duration column formula is: =IF([@[End Time]]="",0,MOD([@[End Time]]-[@Start],1))

thank you so much mate. i will make the correction now.
i am having a bit of trouble with row 34 column V showing #value!

Paste the following into cell V7 and copy down:

Formula:

Please Login or Register  to view this content.

Also, the formula for the cost player column should be changed back to what it was in the file attached to post #15:

Formula:

Please Login or Register  to view this content.

Try the following: =IF([@Duration]=0,"",[@[Gross Profit]]/([@Duration]*24))

thank you. seems to skipped lots of rows, and for the deposit shows #value! in AA34 can it show zero instead and W7 can that value be clear too.

It skips rows where the duration is zero.
For $/hr: =IF(OR([@[Buy-in]]=0,[@Duration]=0),"",[@[Gross Profit]]/([@Duration]*24))
For BI % of BR: =IF([@Tournaments]="","",[@[cost player]]/[@Bankroll])

thank you so much. work perfect., I am working on the bankroll on this thread. I will figure out as much all day today and request the adjustments i can't figure out. so far i got this much in the picture.
can you please see this thread
https://docs.google.com/spreadsheets...it?usp=sharing this is now but i will make the necessary adjustments and re-upload later on tonight.

Selecting the google link produces the following error: "Not Found Error 404"
From looking at the screenshot it appears that the Totals of the Tournament Profit by site section is in need of correction.
Paste the following into cell F33 and drag the fill handle to the right: =SUM(F24:F32)

thank you mate, my bad didn't check link will fixed now.
this is the link to the thread with google sheet fixed.
https://www.excelforum.com/excel-gen...xcel-file.html