Hi! I have the old problem of getting Excel to understand time as duration, not time of day.
Basically, I want to calculate how many pieces a worker does at the end of day, knowing:
pieces/hour and time worked (like 1h30min)
I think I got it to understand time, but can't get it to do the multiplication right with the pieces/hour
Reading some old forums I managed to work around it by adding a cell that represents 1hour and I got this (ex: 20pieces/h, 1h30min worked)
A =20/$Z $1 where Z1 is 1hour
B =1:30 in time format
C =A*B and the result is right, 30 pieces
Yet, I'm anoyed at A column because I constantly need to check if I entered it right to not mess the formula, and I have dozens of entries to do.
Any way to make it easier?
Basically, I want to calculate how many pieces a worker does at the end of day, knowing:
pieces/hour and time worked (like 1h30min)
I think I got it to understand time, but can't get it to do the multiplication right with the pieces/hour
Reading some old forums I managed to work around it by adding a cell that represents 1hour and I got this (ex: 20pieces/h, 1h30min worked)
A =20/$Z $1 where Z1 is 1hour
B =1:30 in time format
C =A*B and the result is right, 30 pieces
Yet, I'm anoyed at A column because I constantly need to check if I entered it right to not mess the formula, and I have dozens of entries to do.
Any way to make it easier?