HELP w/ auto calcualting timesheet

[Empress]

Im horrible in math...and don't understand formulas very well either. takes
me forever to do it manually...I never understood how to count time/hours
very well...(I'm a right brainer!! LOL)

could someone plse give me an easy to understand way how to autocalculate my
timesheet???

takes me forever to do it manually...I never understood how to count
time/hours very well...(I'm a right brainer!! LOL)

 

[JP Ronse]

Hi,

Well, sum should do it.

Suppose you have following data:
A1: 01:30
A2: 04:45
A3: 02:15
A4: =sum(A1:A3) => 08:30

To keep the result in hh:mm format even when greater then 24:00, format A4
with customer format [hh]:mm or [h]:mm

Wkr,

JP

 

[Luke M]

Well, I'm assuming you have some sort of start/stop log. Let's say that you
input the time you start in A2, A3, A4, etc. and time stopped in B2, B3, B4,
etc.
To calculate time taken, in C2, input:
=B2-A2
Format cell to display time, if XL tries to return a decimal number. Copy
this formula down as needed.

Then, at the bottom of column C, add a formula that looks like:
=SUM(C2:C10)
In this case, I'm assuming C10 is the last cell with a formula.

This summation formula tells you the total amount of hours worked. Note that
this should also be formatted to display as time (8:00). If you want a
decimal number, based on hours, change last formula to:
=SUM(C2:C10)*24
The "*24" changes the number to decimal. This is handy if you want to
multiply the hours by a rate, such as a hourly pay rate.

If this doesn't completely help, try posting some examples of the data you
have so far, and what you would like to see.

 

[Gord Dibben]

See Chip Pearson's site for an example timesheet with calculations.

http://www.cpearson.com/excel/overtime.htm


Gord Dibben MS Excel MVP