I need some help with a spreadsheet please. This is a simple spreadsheet I use to track my live poker winnings.
I have the following Columns:
A: Date
B: Start Time
C: End Time
D: Hours
E: Profits
F: Hourly
G: Blank Column
H: Total Hours
I: Total Profit
J: Total Hourly
To preface, the F column for my hourly each session isn't really important but I tossed it in anyway. Columns H/I/J are just sums with 1 row.
My problem is, I start a new row for a date I play poker for a session. I enter the Date in A, Start time in B and End Time in C. It then calculates the total hours for me as a decimal. For example 3:15 PM to 9:30 PM and the D hours column shows 6.25. That all works fine.
The issue is, if I start a session at say 9:00 PM but don't finish till 2:00 AM. If I enter those times I get -19.00 hours played in column D instead of what it should be, 5 hours.... Here is my formula to calculate hours as a decimal:
=((C2-B2)*1440)/60
How can I modify this formula to account for the chance that I play past 12:00 AM?
Thanks for the help.
Bookmarks