1. ## 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. ## 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. ## 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>

4. 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. 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. [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]

7. [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. 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. 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
•