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
Bookmarks