Remember Me?

#1
October 28th 04, 05:05 PM
 Kandice Posts: n/a
Is there a formula that can be used here

I trying to create a formula. I'm currently using MS Excel to get basic
info for my Video rental shop. But I'm having difficulties coming up
with a formula for the below argument

If my CD burn speed is 6MB per minute, how long will it take to burn a
700MB CD...given that each file is about 3MB?

Is there a formula that can be used?

--
Kandice
------------------------------------------------------------------------
Kandice's Profile: http://www.excelforum.com/member.php...o&userid=15838

#2
October 28th 04, 05:39 PM
 Bernie Deitrick Posts: n/a

Kandice,

You don't really need a formula - it will take 700/6 or about 116 minutes.
But I doubt that your write speed is that slow: more likely, it's 6 MB/sec,
so about 2 minutes to burn a CD, if you can maintain that data rate:
typically, you can't, since the disc write speed gets slower the closer to
the center of the disk. Usually 3 to 4 minutes is more common. But the
best way: burn one and see how long it takes.

HTH,
Bernie
MS Excel MVP

"Kandice" wrote in message
...

I trying to create a formula. I'm currently using MS Excel to get basic
info for my Video rental shop. But I'm having difficulties coming up
with a formula for the below argument

If my CD burn speed is 6MB per minute, how long will it take to burn a
700MB CD...given that each file is about 3MB?

Is there a formula that can be used?

--
Kandice
------------------------------------------------------------------------
Kandice's Profile:

http://www.excelforum.com/member.php...o&userid=15838

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Don't be a pain in the ass Setting up and Configuration of Excel 0 January 24th 05 02:49 PM Richard F Excel Discussion (Misc queries) 1 January 20th 05 10:56 PM circeo Excel Discussion (Misc queries) 3 January 17th 05 10:04 PM Neil Bhandar Excel Discussion (Misc queries) 4 January 10th 05 11:55 PM Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 10:02 PM

All times are GMT +1. The time now is 01:57 PM.