Total Time and number of rows in hour

[John-SSI]

Hi, i got a calculated time that have been a worktime in hours,
So now i want to calculate the efficiency.

So person 1 have worked 2,38 Hours and picked 409 rows, So for 2,5 i got 163,6/hour

How can i calculate it from 2:38:09 value?

Br

John

[robert_mika · Accepted solution]

try

=409 / (YourField * 24)

Yourfield is your fields that holds the the time

You can convert that with:

Time#(YourField ,'hh:mm:ss')

[John-SSI]

Thanx, i figured it out 🙂