Friday, May 21, 2010

How do you make a cell autosum into another cell in Excell?

I am trying to have 2 numbers add together in column B to have the sum placed in column C. I am using it as a timecard of sorts and want to place in my time in and out in column B(the same cell) and have the total hours in C. Is that possible? Then I want to use the number in C to mulitply by my hourly wage to place total pay for that day in D. Is this possible?





Thanks for any help. I am thinking I should take the Excel class at the local college.

How do you make a cell autosum into another cell in Excell?
You cant have both time-in %26amp; time-out in the same cell. Then it cant be used for calculations (except with complex formulas)





Better thing to do is put your time-in in column B and time-out in column C and get the difference in column D.





Then you can calculate your day's earning in E using the formula below.


= D1*24*rate per hour





D1 = number of hours worked which is equal to





= Time-out - time-in = C1-B1





Remember times should be in the correct format for these formulas to work. i.e


HH:MM or HH:MM:SS


Eg


B1= 9:00 AM


C1=4:30 PM





So


D1=C1-B1 = 7:30





E1 =D1*24*12 (12=hourly rate)
Reply:no problem!!





in Column C,(4), using 4 for example, fomula will be =sum(B1:B3), then in Column D(4) you enter =c4*12, if hourly rate is 12. this should take care of it.


No comments:

Post a Comment