CuriousGeorg
09-11-2013, 01:23 AM
Good morning,
I have staff who work different hours in a week and I need to establish how many pieces of post they work PER hour for the week
I have the cells set up as:
Hours (in [h]:mm format) and post worked
hours for the week will always be over 24 hence the [h]:mm
the cells show: 28:00 (and formula bar shows 01/01/1900 04:00:00).
If they have completed 47 pieces of post in 28:00 of work. How do I get excel to tell me how many pieces of post have been completed PER hour.:whip
but neither appear to be correct. :(
Any tips? :help
I have staff who work different hours in a week and I need to establish how many pieces of post they work PER hour for the week
I have the cells set up as:
Hours (in [h]:mm format) and post worked
hours for the week will always be over 24 hence the [h]:mm
the cells show: 28:00 (and formula bar shows 01/01/1900 04:00:00).
If they have completed 47 pieces of post in 28:00 of work. How do I get excel to tell me how many pieces of post have been completed PER hour.:whip
but neither appear to be correct. :(
Any tips? :help