[mso] Re: excel formula in a workshheet
- From: "David Smart" <smartware@xxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sat, 3 Nov 2007 21:08:21 +1100
You don't want to add a series of times in, and then also add a series of
times out. You need to subtract the time in from the time out to work out
how many hours were spent for the day. Then add up the time spent figures
for all the days, plus your adjustment at the bottom, for a total for the
week.
Times are entered with a colon, and are stored as days and fractions of
days. The subtraction will give you fractions of a day, and you need to
multiply this by 24 to get hours.
Carrying excess hours forward is something that will depend on how you have
stored the week's times in the first place.
> is it possibly in excel to have negative hours
Not as such. But the result of your calculations will actually be a
floating point number that holds hours and fractions of hours. Such a
number can, of course, be negative.
Regards, Dave S
PS-1 Please do not use "reply" to create a new subject. Your entire
previous question has been quoted in this question. I have deleted it.
PS-2 Please do not type your message entirely in lower case. It is lazy and
not respectful to the readers - whose help you are seeking - and will
possibly cause you to be ignored.
----- Original Message -----
From: "Fitzmaurice, Ann E." <a.e.fitzmaurice@xxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Saturday, November 03, 2007 1:53 AM
Subject: [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
>
*************************************************************
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).
//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:
