+ Reply to Thread
Results 1 to 4 of 4

creating a time/tracking/cost chart

  1. #1
    Registered User
    Join Date
    04-06-2018
    Location
    america
    MS-Off Ver
    2010
    Posts
    30

    creating a time/tracking/cost chart

    hi guys, sorry if this is posted in wrong place

    I want to create for myself....

    So I have lets say 5 credit cards that have a balance on them which are like 0% interest.

    What i want to do is create something where i can put the name of the card, date the balance started and the end date that the 0% ends. what the total initial balance was, how much is left to pay until the 0% runs out.

    So id like to have like a green bar indicating total time from start to end, and with each day it would fill up red.

    Idk if this makes sense. i basically want to be able to track my accounts, so i can easily see how much time i still have on each of the cards until the 0% runs out.

    thank you all

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: creating a time/tracking/cost chart

    There are standard functions for this already in Excel for this, check these
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    04-06-2018
    Location
    america
    MS-Off Ver
    2010
    Posts
    30

    Re: creating a time/tracking/cost chart

    thanks for the reply. did you mean to copy a link after you said "check these"?

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: creating a time/tracking/cost chart

    Nope there built-in functions in Excel for Financial calculations, you use formulas, I don't know the name of the function but you can start by entering a formula and select Financial .
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Time tracking chart with different tracking functions.
    By Alynace in forum Excel General
    Replies: 0
    Last Post: 04-25-2019, 12:42 PM
  2. creating a chart for tracking history prices
    By happydz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-27-2017, 04:12 AM
  3. Need help creating a vehicle tracking log chart
    By escribblings in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-11-2017, 03:59 PM
  4. Replies: 4
    Last Post: 09-09-2014, 01:15 PM
  5. Tracking data changes over time with a chart
    By kmanna in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2014, 05:40 PM
  6. Replies: 1
    Last Post: 08-15-2012, 05:38 PM
  7. I would like to find a templet that does cost reduction tracking
    By Templets in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-02-2006, 04:20 PM

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