very green at this formula stuff?
 

For most of you out there, spreedsheets and computers are very ezy to
use? I have searched high and low for what has got to be the most easy
answer to a simple questions? But, I cannot find the answer? Maybe
this disscussion group can do that for me?


I want to keep track of the hours used working my eBay business? This
would be time doing administrative work,time shopping and reseaching
items, and then listing and shipping them to the buyers. Plus other
work at home functions.

But using the spreedsheet and trying to get a simple start work day
and end workday, and total work hours at the end of the week or
month? I cannot find the infomation on how to use formulas?


any help out there??? Thank-you

very green at this formula stuff?
 

See Excel help : enter FORMULAS

A starter ...

A1=Start time
B1=Finish time

both cells formatted as hh:mm

C1: =MOD(B1-A1,1)

this will cater for times over midnight (in case you have insomnia!)

Result will be time in hours & minutes

If you want time as decimal hours, then:

=MOD(B1-A1,1)*24

so 8 hours 30 minutes will be 8.50

Format the cell as GENERAL or NUMBER

Assuming your hours worked per day are in C1 to C7 then total for a week:

=SUM(C1:C7)

format the cell as CUSTOM =[h]:mm

The [h] allows totalling of hours of 24.

If you are using decimal hours, then just format as GENERAL or NUMBER

Example:

A1=08:00
B1=16:30
C1=08:30 (or 8.50 if decimal)


HTH


" wrote:

For most of you out there, spreedsheets and computers are very ezy to
use? I have searched high and low for what has got to be the most easy
answer to a simple questions? But, I cannot find the answer? Maybe
this disscussion group can do that for me?


I want to keep track of the hours used working my eBay business? This
would be time doing administrative work,time shopping and reseaching
items, and then listing and shipping them to the buyers. Plus other
work at home functions.

But using the spreedsheet and trying to get a simple start work day
and end workday, and total work hours at the end of the week or
month? I cannot find the infomation on how to use formulas?


any help out there??? Thank-you