I would convert everything to fractions of a day like excel does.

this code will convert your hours to excel time format

'Time(hours,minutes,seconds)
Down Time =TIME(INT(410),MOD(410,60),0)
'Put 80 hours in as days
total Hours =80/24
Actual Hours = Total Hours - Down time
Actual Days Worked = Actual Hour /(8/24)
Total Minutes = Actual Hours/ 60

I don't know where the transcribed number comes from.
"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.