Piece per hour

Debbie Dies
Guest
Posts: n/a

 3rd Apr 2004
I want to find out hour many birds I processed in an hour.

I want to enter a start time in cell a1 and a stop time in cell b1.
want cell c1 to automatically calculate how many hours I worked. I
cell d1 I want to enter the number of pieces I produced and then I wan
cell e1 to calculate how many birds I processed per hour.

Example: I start at 8:00 am stop at 4:00 pm. That equals 8 hours.
produced 400 birds in those 8 hours. I can get cell c1 to tell me ho
many hours I worked but I can't seem to get cell e1 to give me how man
birds I produced per hour.

cell a1 = 8:00 am
cell b1 = 4:00 pm
cell c1 = b1-a1
cell d1 = 400
cell e1 = ?????

Can you help

--
Message posted from http://www.ExcelForum.com

JE McGimpsey
Guest
Posts: n/a

 3rd Apr 2004
XL stores times as fractional days, so to convert a time into hours,
multiply by 24:

E1: =D1/(C1*24)

In article <(E-Mail Removed)>,
Debbie Dies <<(E-Mail Removed)>> wrote:

> I want to find out hour many birds I processed in an hour.
>
> I want to enter a start time in cell a1 and a stop time in cell b1. I
> want cell c1 to automatically calculate how many hours I worked. In
> cell d1 I want to enter the number of pieces I produced and then I want
> cell e1 to calculate how many birds I processed per hour.
>
> Example: I start at 8:00 am stop at 4:00 pm. That equals 8 hours. I
> produced 400 birds in those 8 hours. I can get cell c1 to tell me how
> many hours I worked but I can't seem to get cell e1 to give me how many
> birds I produced per hour.
>
> cell a1 = 8:00 am
> cell b1 = 4:00 pm
> cell c1 = b1-a1
> cell d1 = 400
> cell e1 = ?????
>
> Can you help?
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Debbie Dies
Guest
Posts: n/a

 3rd Apr 2004
Thank You JE. It worked! I really appreciate your quick response.
JE McGimpsey wrote:
> *XL stores times as fractional days, so to convert a time int
> hours,
> multiply by 24:
>
> E1: =D1/(C1*24)
>
> In article <(E-Mail Removed)>,
> Debbie Dies <<(E-Mail Removed)>> wrote:
>
> > I want to find out hour many birds I processed in an hour.
> >
> > I want to enter a start time in cell a1 and a stop time in cell b1

> I
> > want cell c1 to automatically calculate how many hours I worked

> In
> > cell d1 I want to enter the number of pieces I produced and then

> want
> > cell e1 to calculate how many birds I processed per hour.
> >
> > Example: I start at 8:00 am stop at 4:00 pm. That equals 8 hours.

> I
> > produced 400 birds in those 8 hours. I can get cell c1 to tell m

> how
> > many hours I worked but I can't seem to get cell e1 to give me ho

> many
> > birds I produced per hour.
> >
> > cell a1 = 8:00 am
> > cell b1 = 4:00 pm
> > cell c1 = b1-a1
> > cell d1 = 400
> > cell e1 = ?????
> >
> > Can you help?
> >
> >
> > ---
> > Message posted from http://www.ExcelForum.com/
> >

--
Message posted from http://www.ExcelForum.com

=?Utf-8?B?U2h1YmhrYXJhbg==?=
Guest
Posts: n/a

 24th Apr 2004
We should use time as 24 hours insted of AM/ PM. In your case you shuld use 8.00 (in place of 8 AM) and 16.00 (in place of 4.00 PM. I think problem will solve

----- Debbie Dies > wrote: ----

I want to find out hour many birds I processed in an hour

I want to enter a start time in cell a1 and a stop time in cell b1.
want cell c1 to automatically calculate how many hours I worked. I
cell d1 I want to enter the number of pieces I produced and then I wan
cell e1 to calculate how many birds I processed per hour.

Example: I start at 8:00 am stop at 4:00 pm. That equals 8 hours.
produced 400 birds in those 8 hours. I can get cell c1 to tell me ho
many hours I worked but I can't seem to get cell e1 to give me how man
birds I produced per hour

cell a1 = 8:00 a
cell b1 = 4:00 p
cell c1 = b1-a
cell d1 = 40
cell e1 = ????

Can you help

--
Message posted from http://www.ExcelForum.com

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Tia Microsoft Access Forms 1 9th Nov 2009 12:05 AM dean Windows XP General 0 21st May 2006 03:46 PM =?Utf-8?B?TmFsaWNl?= Microsoft Powerpoint 1 11th May 2005 02:29 PM =?Utf-8?B?dG9yY2hfbXVzaWM=?= Microsoft Excel Programming 2 18th Mar 2005 01:26 PM =?Utf-8?B?UFM=?= Microsoft Access Database Table Design 1 6th Feb 2005 05:04 AM

Features