[mso] excel formula in a workshheet

hi
 
have a form were the data is entered as time stated and time finished on a 
daily basis and then a calcuation is made to total the housrs worked per week 
how do you add up a series of times in and a series of time out  
 
there is a possibility that additional hours need to be added to this total and 
this is done as a an adjustment and the totals summed to gove a running total.
 
a working week is 37 hours and where the total hhours worked is greater than 37 
the extra hours are carried forward to the following week
 
where the hours worked are less than 37 and assuming no hours carried foreward, 
the following week starts with a debit number of hours. is it possibly in excel 
to have negative hours
 
can suppy example of form if necessary
 
ann
 
 
 
Ann E Fitzmaurice
Medical Statistician
Immpact ,University of Aberdeen
Health Sciences Building
Foresterhill
Aberdeen, AB25 2ZD
Scotland

Tel: +44 (0)1224 553876 

 Fax: +44 (0)1224 555704

Email:  <mailto:a.e.fitzmaurice@xxxxxxxxxx <mailto:a.e.fitzmaurice@xxxxxxxxxx> 
> a.e.fitzmaurice@xxxxxxxxxx



________________________________

From: Fitzmaurice, Ann E.
Sent: Tue 30/10/2007 15:40
To: 'mso@xxxxxxxxxxxxx'
Subject: RE: [mso] Re: Date format in Excel - really XY graph for ANN M



Thankyou for the replies re the scatter graph using a column with countries, 
the solution was to hightlight the three columns and plot the graph and then 
when hovering over a point the following info would appear, country x and y 
points, unfortunately there are 100 lines and hence 100 countries, so what I am 
trying to do is plot the scatter graph and when I hover over a point it shows 
that particular country and the values

Any ideas 

Thanks in anticipation 

Ann 


Ann E Fitzmaurice 

Medical Statistician 

Immpact 

University of Aberdeen 

Health Sciences Building 

Foresterhill 

Aberdeen, AB25 2ZD 

Scotland, United Kingdom 

Tel: +44 (0)1224 553876 

Fax: +44 (0)1224 555704 

Email: a.e.fitzmaurice@xxxxxxxxxx 

url: http//www.immpact-international.org/ 


-----Original Message----- 
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of 
Tillotson, Robert N (US SSA) 
Sent: 30 October 2007 12:57 
To: mso@xxxxxxxxxxxxx 
Subject: [mso] Re: Date format in Excel - really XY graph for ANN M 



Ann 
I am assuming your data in in three columns next to each other.  This 
works for Excel 2003. 
When you create the graph, select all the data in the three columns 
before you click the chart wizard. Then click the chart wizard button 
(or however you start the wizard in your version). Select scatter graph 
and accept all the defaults for the chart.  Don't choose to label the 
points.  Then when you hover over a point it will list the country as 
the point name and the x and y as values for it, like: series 1  point 
"Albania" (23, 34).=3D20 


Robert Tillotson 
BAE-IT 
Groton Field Office 
860-441-2207 

-----Original Message----- 
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On 
Behalf Of ANN FITZMAURICE 
Sent: Tuesday, October 30, 2007 3:51 AM 
To: mso@xxxxxxxxxxxxx 
Subject: [mso] Re: Date format in Excel 

hi 
=3D20 
Am trying to draw a scatter graph in excel, have 3 column , name of 
country , x value and y value, I can draw the x y graph using scatter 
graph , what I want to do is when I hover over a point I want to be able 
to read the point values in addition to the name of the country, I can 
at present read the x y values but not the name of the country. I do not 
want to have the values reproduced on the graph as there are too many 
points for the values to be read =3D20 =3D20 Any help =3D20 =3D20 ann 
************************************************************* 
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx 
or MicrosoftOffice@xxxxxxxxxxxxxxxx 

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx 

To Unsubscribe from this group, visit the group's homepage and use the 
dropdown menu at the top.  This will allow you to unsubscribe your email 
address or change your email settings to digest or vacation (no mail). 
http://www.freelists.org/webpage/mso 

To be able to share files with the group, you must join our Yahoo sister 
group.  This group will not allow for posting of emails, but will allow 
you to join and share problem files, templates, etc.: 
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for 
FILE SHARING ONLY. 

If you are using Outlook and you see a lot of unnecessary code in your 
email messages, read these instructions that explain why and how to fix 
it: 
http://personal-computer-tutor.com/abc3/v28/greg28.htm 
************************************************************* 
************************************************************* 
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx 
or MicrosoftOffice@xxxxxxxxxxxxxxxx 

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx 

To Unsubscribe from this group, visit the group's homepage and use the 
dropdown menu at the top.  This will allow you to unsubscribe your email 
address or change your email settings to digest or vacation (no mail). 
http://www.freelists.org/webpage/mso 

To be able to share files with the group, you must join our Yahoo sister 
group.  This group will not allow for posting of emails, but will allow 
you to join and share problem files, templates, etc.: 
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for 
FILE SHARING ONLY. 

If you are using Outlook and you see a lot of unnecessary code in your 
email messages, read these instructions that explain why and how to fix 
it: 
http://personal-computer-tutor.com/abc3/v28/greg28.htm 
************************************************************* 
************************************************************* 
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx 

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx 

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).

http://www.freelists.org/webpage/mso 

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:

http://personal-computer-tutor.com/abc3/v28/greg28.htm 
************************************************************* 


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: