Calculating Units

Hi All,

I need a help on caluclating units. I have the below data :

TIME Units
A 0:05:00
B 0:07:13
C 0:10:10
D 0:02:06

keeping A as 00:05:00 as 1 units. I need to calulate units for the rest..pls help ASAP...

Hi,

Better clarification and explanation on your need, might be helpful here to give some direction. Also please post an excel sheet with the sample input data and the desired result you are expecting.

thanks

In the attached sheet, i want to calculate the unit based on lowest time taken for 1 line and the target per day. as tyoe has diff timing.

Hi Anjali,

So if I read your excel sheet right,

Time taken per line is 5 mins.
Target per 8 hours - ? - Your desired result is 96. Did I read that right? or Am i missing something.

Also Is Time taken per line, data will be typed manually ?

Hi,

I need to calculate the units forthe below data. total time differe for every report as per no of line..now how do i fix the target for 8 hrs. 1 report is completed when alll line r processed and other activites are done.

Type of Report No of rows Time taken per line Time for other task to compete report Total time completion of 1 request Units Target
a 10 0:01:45 0:04:00 0:05:45
b 20 0:01:50 0:05:05 0:06:55
c 15 0:02:00 0:10:05 0:12:05
d 21 0:01:54 0:07:00 0:08:54

psl find the excl attachment.