With the current consumer grade DVDs, your current DVD player will not support larger media. 4.7 GB per layer is all that the current technology will support.
The way that the movie studios get around this is that their DVDs hold 4.7 GB of data to the outer ring and then when the laser gets to the edge, it switches frequencies and reads the disc again.
Unfortunately, writeable DVDs must be opaque and do not have the ability to do this as of yet. However, double sided blank DVD media will work well! (4.7 GB per side = 9.4 GB total). However, the DVD must be flipped over if the movie is larger than 4.7 GB.
How Excel Sees Time.
Before you delve into Excel’s date functions, however, it helps to understand a bit about the serial numbers the program uses for this type of calculation. Excel for Windows uses the 1900 Date System, in which serial numbers range from 1 to 65,380, corresponding to Jan. 1, 1900, through Dec. 31, 2078.
In this system, Jan. 1, 1900, has a serial date of 1, while Dec. 31, 2078, has a serial date of 65,380 to represent the number of days after Jan. 1, 1900.
Because the program keeps track of a date or time function’s underlying serial number, it can easily perform calculations using it. For example, you can calculate how many days have transpired since you billed a client or the number of days until your vacation.
In Word you can make the date "stick" if you select the date and press Ctrl-Shift-F9 to convert the date field to simple text. Save your document after this change to make the date entry permanent.
Current date: Ctrl+;
Current time: Ctrl+Shift+;
Ctrl+Shift+~
Question:
Which function should you use if you want a permanent date to display in the workbook?
Answer:
You should enter the date directly into the workbook without using a function.
