Off-line Netscape and adding Excel dates




On the subject of starting Netscape without going on-line, if you open a file on your hard disk with the extension JPG or HTML, it opens Explorer without going through all the waiting. If the setting for these file types in Open with is changed to Netscape, then it should do the same trick. Then all you have to do is put a copy of a JPG or HMTL file on your desk to have fast access.
This will work with any program. For example, if you work on more than one spreadsheet all the time just drag them to your desktop in Windows 95, or with Windows 3.x make a new program group and just drag the files you want from File Manager to the new group. This might not be the approved way of doing things, but it works. Love the mag and keep up the good work, keeping us up to date on what is happening out there. By the way, is there an easy way of getting Excel to add time values? Bye and hang loose.
- Dave Turner


Thanks for the tip on off-line Netscape, Dave. I'm almost too loose to continue, but adding time values in Excel is something we've covered a couple of times in Help Screen. Basically, times are in a generic format, which is the number of days since January 1, 1900 or something. Hour, minutes and seconds are just numbers to the right of the decimal point. You can add and subtract time values -- even multiply them -- because they're just numbers.
The trick is to format the dates the way you want them displayed in the cells. You can display just the day, or the day/month/year, or the seconds, or just the time of day, and so on. Check out page 180 of our May issue for details.
- Neale Morison


Category: Spreadsheet, Internet
Issue: Sep 1996
Pages: 152

These Web pages are produced by Australian PC World © 1997 IDG Communications