Formula to determine minutes per item.

[Sipperphoto]

Hey all,

Total Excel newb here. I'm a photographer and trying to trying to make a spreadsheet where I can enter in the amount of product we shoot in a day, the amount of hours worked and have it spit out minutes per item column. I've Googled and found a few formulae but none seem to work, or work the way I want them to.

Is this even a possibility?

TIA

Jeff

 

[Sipperphoto]

Excellent! I think we are close.

If I am testing it with Amount of items=60, Hours=1:00 I am getting .02 as my time per shot. Is that right? I have that Cell Formatted with Number, not Time.

 

[Brian from Maui]

Please be aware that there is a difference when converting time values to a decimal number. For time on the hour i.e. 7:00, the decimal equivalent is 7. But 7:30 is 7.5 and not 7.3. Multiplying by 24 converts time values to a decimal number. so please be careful when dealing with time values.

 

[Brian from Maui]

Excellent! I think we are close.

If I am testing it with Amount of items=60, Hours=1:00 I am getting .02 as my time per shot. Is that right? I have that Cell Formatted with Number, not Time.

I apologize. If you want the average per minute, it's (E2*1440)/D2 for 1. For per hour it's (D2/(E2*24) for 60

 

[Sipperphoto]

Sounds good. Thank you so much for your ongoing help here. I guess I'm still just slightly confused as to why at 60 items per hours, I'm getting 0:24 as my answer. Shouldn't I be getting 1, as in 1 minute?

Sorry if I sound like an idiot here... like I said, Excel is a foreign language to me!

 

[Brian from Maui]

Sounds good. Thank you so much for your ongoing help here. I guess I'm still just slightly confused as to why at 60 items per hours, I'm getting 0:24 as my answer. Shouldn't I be getting 1, as in 1 minute?

Sorry if I sound like an idiot here... like I said, Excel is a foreign language to me!

No worries.

If you want 1 as the answer to 60 items in 1 hour, use

=(E2*1440)/D2

Where E2 houses 1:00 and D2 houses 60. 1440 is the number of minutes in a day. If you increase 60 to 120, you'll get .05.

 

[Sipperphoto]

BOOM!

That's it! Thank you sooooo much!