[mso] Re: Calculating Elapsed time in Excel
- From: Gary Montgomery <glmontgomery@xxxxxxxxxx>
- To: "Linda Johnson" <mso@xxxxxxxxxxxxx>
- Date: Sat, 29 Jun 2002 12:25:22 -0400
Hi Linda!
I did what you said below. It got me closer but no bananas. It
worked on the top 2 but example #3 it didn't. Also, when I go
to take column D x rate per hour it gives me a error. After
determining the number of hours worked I want column e to be d
* rate per hour = $$ to give me total $ earned for the day. I
thought this would be simple but I must be missing something.
Thanks for your help. I know Excel is capable of doing what I
want to do but just finding the right combination of formating
the clock in and out and formulas to determine the elapsed time
in hundreds * rate per hour.
Have a great day!
Gary :-)
________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag
---- On Tue, 25 Jun 2002, Linda Johnson (linda@personal-
computer-tutor.com) wrote:
>
> Hi Gary
>
> Format column D as Custom h:mm
>
> Then put this formula is D and drag it down the column
>
> =(B2-A2)-TIME(0,30,0)
>
> Linda
> Publisher ~ ABC ~ All 'Bout Computers
> Owner ~ Linda's Computer Stop
> http://personal-computer-tutor.com
> FREE MS Office eBook Tutorial
> http://personal-computer-tutor.com/library.htm
>
>
>
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-
bounce@xxxxxxxxxxxxx] On
> Behalf Of Gary Montgomery
> Sent: Tuesday, June 25, 2002 8:53 PM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Calculating Elapsed time in Excel
>
>
>
> I am trying to design a payroll sheet. In column B I have
> the "Clock In" time and column C I have the "Clock Out" time.
> In column D I want Excel to calculate the elapsed time in
Hours
> and hundreds of hours. Our time clocks prints the clock in
and
> clock out times in time format (11:15 = 15 minutes after 11
> O'clock. 15:30 = 3:30 p.m.)
>
> B C D
> 7:00 15:30 8.0 (8.5 hrs minus .50 for lunch)
> 7:30 15:00 7.0 (7.5 hrs minus .50 for lunch)
> 7:45 12:45 4.5 (5.0 hrs minus .50 for lunch)
> I know Excel can do this but I have tried different formats
and
> formula's I can't seem to get the right results.
> I would appreciate if anybody knows what each cell needs to
be
> formated as and what formula to use in column D.
>
> Thanks in advance for your help.
> Gary :-)
>
>
> *************************************************************
> 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, send an email to
> mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
>
> Or, visit the group's homepage and use the dropdown menu.
This will also allow you to change your
> email settings to digest or vacation (no mail).
> //www.freelists.org/webpage/mso
>
> To be able to use the files section for sharing files with
the group, send a request to
> mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a
> member of the files group, you can go here to upload/download
files:
> http://www.smartgroups.com/vault/msofiles
> *************************************************************
>
>
*************************************************************
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, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
