+ Reply to Thread
Results 1 to 3 of 3

Time difference formula help

Hybrid View

  1. #1
    Registered User
    Join Date
    05-24-2011
    Location
    FL
    MS-Off Ver
    Excel 2003
    Posts
    3

    Time difference formula help

    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.

  2. #2
    Registered User
    Join Date
    05-24-2011
    Location
    FL
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Time difference formula help

    here is the excel file i have so far if that is any help.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-24-2011
    Location
    FL
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Time difference formula help

    I think I found the answer and it seems to work:

    =MOD(C2-B2,1)*24

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1