HELP w/ auto calcualting timesheet
 

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)

HELP w/ auto calcualting timesheet
 

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



"Empress" <u54241@uwe wrote in message news:9b1468333d54e@uwe...
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)

HELP w/ auto calcualting timesheet
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Empress" wrote:

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)

HELP w/ auto calcualting timesheet
 

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

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


Gord Dibben MS Excel MVP

On Mon, 24 Aug 2009 15:05:23 GMT, "Empress" <u54241@uwe wrote:

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)