Can anyone help with formulas for a Spreadsheet?

Question

I am making a time sheet for work, so i make sure they are not shorting me on money like some others at work, and i need some formulas that might help total the total amount time worked for every day... for example, Tuesday: time in: 11 pm, break 1: 1:30 am to 1:45 am, etc. I have 2 breaks and 1 lunch and i need to log what time in and out, so i can see total hours, minutes for the day. Anyone able to help!?

Answer 1

The best thing I can recommend is going to Microsoft's site and get one of the free Templates there are some good ones
for time sheets that already have the formula's built in them.
Here is the link to the templates.

http://office.microsoft.com/en-us/templates/FX100595491033.aspx?pid=CL100632981033

Answer 2

Hi tausha87,

Do you see the FX, insert function right beside the Green Tick?

That is to insert the formulas (please pardon if you already know):

Make sure the Hours are in 24 hours format:
hh:mm

then

Do it like this in the columns:

Row A Time Out:
Row B Time In:
Row C Breaks:
Row D Total hours

(If there are more breaks, just add more rows, just make sure total hours is in the last row)

Highlight the three boxes vertically down and in the total hours box, insert the formula: In this example:

Row A - Row B - Row C

And the answer will be in Row D: Total Hours Row.

If you want to count how much you are paid, just add another Row after the "Total hours" Row and put "Salary Earned" and in the formula box, put "Row D * N" where N is the hourly wages.

I tried it on excel before posting this, Hope this helps!

Eric Chua Yanshan Maynas
Researcher of Renewable Energy

www.ericyanshan.blogspot.com
www.outerheavens.blogspot.com
www.superchangingworld.blogspot.com

Answer 3

Hi , this solution might help in your spreadsheet problem.

Come In : 8:30:00AM (Box A1)
Lunch Out :12:30:00PM (Box B1)
Lunch In :13:30:00PM (Box C1)
Bye-bye : 18:00:00PM (Box D1)
Total hour : D4

In box D4 please enter The following formula =sum((B1-A1)+(D1-C1))*24.

Note:
In box A1,B1,C1,D1 adjust the format cell to time value (right click select format cell , inside category)

In Box D4 adjust the format cell to monetary/no. value (right click select format cell, inside category)

any question , e-mail me.