//flex table opened by JP

Click to See Complete Forum and Search --> : i was wondering if there is a program like this for free?


GroundZero3
07-18-2000, 01:17 PM
i started a job and i was wondering if there a program where i can type in my hours and type in my hourly wage and it will caculate what i have earned so far? Just wondering
JaYsin

[This message has been edited by GroundZero3 (edited 07-18-2000).]

Gomer
07-18-2000, 01:23 PM
Start->Programs->Accessories->Calculator

Hours Worked times Wage equals Earnings

For a more in depth look taking taxes into account, any spreadsheet program will do. You will have to set it up though.

[This message has been edited by Gomer (edited 07-18-2000).]

SoopaStar
07-18-2000, 05:09 PM
I would use Excel to do it...in fact I do have a spread sheet I made.
Paul

GroundZero3
07-18-2000, 09:02 PM
Hey soopa do you know a web site where it can explain on how to setup excel to caculate that?
JaYsin

SoopaStar
07-18-2000, 10:27 PM
its really easy. lets say you put your hours in column A. Say you are doing it for 5 days so you use A1 though A5. Then in row 7, you would put this code (assume the pay rate is $7.50 an hour)
A
1 6.25
2 5.75
3 4.30
4 8.15
5 6.80
6 Total
7 =sum(A1:A5)
8 Total Pay
9 =(7.50*A7)
That should do it. If you right click on the cell and choose "format cells". Then on teh number tab you can format the cells to Currency. Enjoy!
Paul
6.25

howste
07-19-2000, 08:32 AM
If you enter it the way shown above, you have to convert it into decimal first (i.e. 3:15 = 3.25). It gets a little trickier if you want to enter the time in the HH:MM format. I have a time sheet spreadsheet I did for someone a while back which I'll email to you.

Steve

skywalker[TSG]
07-19-2000, 11:39 AM
if you dont have exel you can download star officefor free @ http://www.sun.com
its 58mb dough but it contains everyting that office 97pro has to offer

[This message has been edited by skywalker[TSG] (edited 07-19-2000).]

wyvrn
07-19-2000, 07:51 PM
I am just learning VB. I think I will write a program to do just this, if you want it. Sounds like fun!! http://sysopt.earthweb.com/forum/smile.gif