Hi,

I'm not too sure about the maths (410/60=6.83 not 6.5) but try this in
Colimns A & B starting in Row 1.

The formula that gives 96.81 is
=B3/((B1-(B2/60))/8)

Worked hrs 80
Downtime (M) 410
Tot mins transcribed 885.4
Average mis transcribed 96.81

Mike


"Ladyrose" wrote:

I need help with a formula. I need to perform a succession of calculations
for a monthly work summary and can't figure out how to write the formula or
how to format the cells. I am going to describe how we do this manually:
Downtime minutes (410) divided by 60 = DT hours (6.5). DT hours subtracted
from Total Hours Worked (80)= Actual Hours Worked (73.5). AHW divided by 8
= Actual Days Worked (9.18). Total Minutes Transcribed (885:40) divided by
ADW = Average Minutes Transcribed per day(97.08 roughly), realizing that a
calculator cannot calculate minutes and seconds accurately. There is a cell
for Total Downtime Minutes, Total Hours Worked, Total Minutes Transcribed,
Total Days Worked, and Average Minutes Transcribed. I would be grateful for
any help at all.
Thanks so much in advance.