Dividing time by number 2

[Bandenjamin]

Hey all,

I've seen this question posed a couple of different ways but I still can't seem to get it to work using the forumlas I see. First here is what I'm trying to get at.

I have a cell that has a number of hours, Minutes seconds (h:mm:ss) This is a total of work time for a week. Ie 34:09:47. I have another field that has a total number of issues worked on that week. ie 55. Now I want to find out what the average number of issues worked on that week was.

if I divided 34:09:47/55 I get .03 which is obviously wrong. I tried doing the 34:09:47*24*60*60 to get a digital number and then divide that number by 55 but there I get 2214. Basically way off.

What I am expecting is this.

[tt]
Hours Worked Issues Average
34:09:47 55 1.73
[/tt]

Thanks,


--Dan
Whenever you find yourself on the side of the majority, it is time to pause and reflect.
Mark Twain

 

[AnotherHiggins]

->I want to find out what the average number of issues worked on that week was.

That makes no sense. If you have 55 items, there is no average needed to know how many items were worked on. 55 items were worked on.

The formula you tried to use is:
[tab]34:09:47/55
That's TIME/ITEMS and, sure enough, will give you the average TIME PER ITEM.

Is that what you want? If so, then let's look at your example:
[tt]
A B C
1 Hours Worked Issues Average
2 34:09:47 55 [/tt]

In C2, place this formula:
[tab]=[COLOR=blue white]A2/B2[/color]

That will give you 0:37:16, meaning that each issue was worked on for an average of 37 minutes 16 seconds.

Alternately, if you are looking for the average number of issues worked on per hour, that would be
[tab]=[COLOR=blue white](B2/A2)/24[/color]
Which is (ITEMS/TIME)/# HOURS IN A DAY

That will give you 1.6099.

All of that leads me to wonder: [!]By what logic are you expecting to get "1.73"????[/!]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[Lilliabeth]

Now I want to find out what the average number of issues worked on that week was.

I certainly may be misunderstanding, but is that what you want - isn't that what 55 is?

Do you want the average amount of time an issue took?

Test this!!

If 55 is in A1 and the time is in B1

=A1/(B1*24)
Format the answer as a number

Lilliabeth
-Why use a big word when a diminutive one will do?-

 

[Lilliabeth]

Do you want the average amount of time an issue took?

Sorry, I of course meant to say number of issues per hour, but had been wondering which he wanted.

Lilliabeth
-Why use a big word when a diminutive one will do?-

 

[Bandenjamin]

That's it!, stars for both of you. It's Monday, and I'm trying to do too many things at a time and misspoke. I was looking for the average per hour.

Thanks,

--Dan
Whenever you find yourself on the side of the majority, it is time to pause and reflect.
Mark Twain