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

 

[Brian from Maui]

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

On the surface, it's

=time/no. of products

I'm sure there's more to this. Can you post some samples and expected results?

 

[Sipperphoto]

Thanks Brian

That's basically it. Here is what I started to get together. Right now it's giving me fractions of a minute, and it would be nice if I could get just minutes to read out:

Imgur: The most awesome images on the Internet

 

[Brian from Maui]

Thanks Brian

That's basically it. Here is what I started to get together. Right now it's giving me fractions of a minute, and it would be nice if I could get just minutes to read out:

Imgur: The most awesome images on the Internet

I'm at work and unable to open your links.

Can you post some examples with expected results? You'll get a lot more answers.

 

[Sipperphoto]

Brian,

It's not letting me post a screenshot, but here is about what I have going on:

Products . Hours. Avg Time per shot
100 . 7 . 0.009920635

I'd like to get the Avg time per shot to read something like 4:00 (as in 4 minutes)

 

[Brian from Maui]

Brian,

It's not letting me post a screenshot, but here is about what I have going on:

Products . Hours. Avg Time per shot
100 . 7 . 0.009920635

I'd like to get the Avg time per shot to read something like 4:00 (as in 4 minutes)

change the 7 to 7:00 and format the cell that houses the formula as Time, with type as 13:30.

 

[Sipperphoto]

I think we're getting closer, but I'm not sure I have the formula right... when I increase the amount of products, the Time per shot goes up, instead of down... Here is the formula I have in there:

=(D2/(E2*24))

 

[Brian from Maui]

I think we're getting closer, but I'm not sure I have the formula right... when I increase the amount of products, the Time per shot goes up, instead of down... Here is the formula I have in there:

=(D2/(E2*24))

By multiplying by 24, you're converting a decimal number. Is D2 time or number of items?

=It's Time/Items

 

[Sipperphoto]

Yes. D2 is the amount of items. How should my formula look?

 

[Brian from Maui]

Yes. D2 is the amount of items. How should my formula look?

Try,

=(E2*24)/D2

Where E2 houses the time. The cell that houses this formula is also formatted as a Number with however many decimal places you choose.