If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Please help an Excel Newbie!
I am trying to use Excel to make a simple time tracker. This is the basic set up of my page: Cells A4-R4 contain # of hours worked per day, say 5:30 (Time) in each cell. Cell A2 is a running total of A4-R4. This formula I have already done. =SUM(A4:R4) Cell A3 is the % of a total # of hours available that A2 is. For example; A2 is 40 and the total available # of hours is 100 (which is A1) then A3 would be 40%. What would be the formula used to show the percentage of A1 that A2 is if A1 is a number such as 100 and A2 is in time format? When I format A2 to time my % gets screwed up each time I try it. Any ideas? A1 is not in time format but is a General number format. I also have A5, which is a running total of A1 (100) - A2. This also does not work when I have A2 in time format. It gives me a number which is close to the correct answer but just a little off. Any help I coul get would be appreciated! Thanks, Terry -- Mustangman ------------------------------------------------------------------------ Mustangman's Profile: http://www.excelforum.com/member.php...o&userid=29903 View this thread: http://www.excelforum.com/showthread...hreadid=496096 |
#2
|
|||
|
|||
Please help an Excel Newbie!
Try
=(SUM(A4:R4)*24)/A1 format as percentage since one excel hour is 1/24 then you need to multiply with 24 to get decimal format -- Regards, Peo Sjoblom (No private emails please) "Mustangman" wrote in message ... I am trying to use Excel to make a simple time tracker. This is the basic set up of my page: Cells A4-R4 contain # of hours worked per day, say 5:30 (Time) in each cell. Cell A2 is a running total of A4-R4. This formula I have already done. =SUM(A4:R4) Cell A3 is the % of a total # of hours available that A2 is. For example; A2 is 40 and the total available # of hours is 100 (which is A1) then A3 would be 40%. What would be the formula used to show the percentage of A1 that A2 is if A1 is a number such as 100 and A2 is in time format? When I format A2 to time my % gets screwed up each time I try it. Any ideas? A1 is not in time format but is a General number format. I also have A5, which is a running total of A1 (100) - A2. This also does not work when I have A2 in time format. It gives me a number which is close to the correct answer but just a little off. Any help I coul get would be appreciated! Thanks, Terry -- Mustangman ------------------------------------------------------------------------ Mustangman's Profile: http://www.excelforum.com/member.php...o&userid=29903 View this thread: http://www.excelforum.com/showthread...hreadid=496096 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dynamic Excel chart in PowerPoint... | Rob | Powerpoint | 5 | November 5th, 2005 03:32 AM |
Can we import an Excel sheet to use as base for report? | StargateFan | New Users | 9 | November 4th, 2005 07:32 PM |
Display form from an VB application in Excel | kuhni | General Discussion | 0 | August 10th, 2005 06:04 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |
Ctrl+A macro fix for problem in Excel 2003 | David McRitchie | General Discussion | 4 | June 19th, 2004 12:01 PM |