Time calculation

  • Thread starter Thread starter brianwa
  • Start date Start date
B

brianwa

Hello all,

I need some help with a time calculation. What I need to find out ho
much time an employee does a certain task on a daily basis.

Here is an example of what I have so far.
in B21 I have a value of 27.7 (this is the number of tasks).
in A50 I have .0025 formatted to mm:ss to show 03:36. This is a
average of how long each task should take to complete.
Here is the formula I am using to calculate the average time per day:
=B21*MINUTE($A$50)/60

Any ideas where I've gone wrong?

Thanks in advance,
B
 
It's not clear what you're trying to do. You said you want the average time
but you also said the average is 03:36. If you have 27.7 tasks and each
takes 03:36 then the total time s/b =B21*A50 or 1:39:43.

--
Jim Rech
Excel MVP
| Hello all,
|
| I need some help with a time calculation. What I need to find out how
| much time an employee does a certain task on a daily basis.
|
| Here is an example of what I have so far.
| in B21 I have a value of 27.7 (this is the number of tasks).
| in A50 I have .0025 formatted to mm:ss to show 03:36. This is an
| average of how long each task should take to complete.
| Here is the formula I am using to calculate the average time per day:
| =B21*MINUTE($A$50)/60
|
| Any ideas where I've gone wrong?
|
| Thanks in advance,
| BW
|
|
| ---
| Message posted
|
 
Back
Top