Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Park City, Utah
    Posts
    189
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Time Tracking Spreadsheet (2003)

    I am trying to use a simple spreadsheet to track and charge for time. The attached shows what I need including my feeble attempt at formulas, which since I am posing here, are not working. I would like the total time shown in minutes. Any help is greatly appreciated!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Time Tracking Spreadsheet (2003)

    Cell F2 contains the time in minutes, but it is formatted incorrectly. If you select F2, then Edit | Clear | Formats, you'll see the number of minutes (291). I'm not sure what you want in G2, but you should clear the formatting there too probably.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Time Tracking Spreadsheet (2003)

    I see a couple of four things:

    1- Cell F2 is correctly calculating the number of minutes but it is formatted incorrectly. If you want the whole number of minutes, I would recommend formatting the cell as a Number with zero places after the decimal. Because of the way Excel keeps time values in binary, you could end up with fractional minutes after the calculation, even though you entered whole minutes in the start and stop times.

    2- Because of the possibility of getting fractional number of minutes as described above, I would recommend that you change the formula in cell F2 the the formula below. If you don't, and you add up the numbers in column F you may get a different result than you would get if you add the displayed minutes with a calculator.

    <pre>=ROUND((E2-D2)*1440,0)
    </pre>


    3- I believe that column G needs to be formatted as a currency (dollars ?). Because you used a value that was formatted as a time in that calculation it is automatically formatted as a time. It looks like you were trying to calculate a billing amount there.

    4- For the same reason as described in 1 & 2 above, I would recommend changing the formula in G2 to:

    <pre>=ROUND(F2*0.583,2)
    </pre>

    Legare Coleman

  4. #4
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I was searching for this topic so I could make a time tracking worksheet; my search found this post but the attachement is missing or I don't know where to find it.

    Is the attachment available?

    [quote name='HansV' post='492174' date='25-Jun-2005 15:48']Cell F2 contains the time in minutes, but it is formatted incorrectly. If you select F2, then Edit | Clear | Formats, you'll see the number of minutes (291). I'm not sure what you want in G2, but you should clear the formatting there too probably.[/quote]

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Unfortunately, the attachment was lost (with a lot of others) in the server crash of August 2007.

    Perhaps you can use the Timecard template - see Use the Excel Timecard template for quick and easy time tracking.

  6. #6
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='784969' date='17-Jul-2009 02:23']Unfortunately, the attachment was lost (with a lot of others) in the server crash of August 2007.

    Perhaps you can use the Timecard template - see Use the Excel Timecard template for quick and easy time tracking.[/quote]


    perhap you would start a new thread with your file attached
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='franciz' post='784970' date='16-Jul-2009 20:34']perhap you would start a new thread with your file attached[/quote]
    Huh?

  8. #8
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Okay, thanks, I will see if I can adapt those to my needs.

    [quote name='HansV' post='784969' date='16-Jul-2009 11:23']Unfortunately, the attachment was lost (with a lot of others) in the server crash of August 2007.

    Perhaps you can use the Timecard template - see Use the Excel Timecard template for quick and easy time tracking.[/quote]

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Also see Working With Times Example Page on Chip Pearson's website. There are some links at the bottom to download a sample workbook and to view related sites.

Posting Permissions

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