Keynotes downloadable from iTMS
Many messages similar to the following always appear on various mailing lists and web forums just after the Keynotes given by Steve Jobs If anyone can download a copy of the Steve Jobs 2006 Macworld Keynote which can be watched here: http://stream.qtv.apple.com/events/jan/mw2006/m_mw_2006_350_ref.mov Apparently, you cannot save it to hard disc--but maybe there is a workaround? We would like to show it to the group at our meeting this week. But unfortunately Apple do not provide a downloadable version, only the streamed version. Which I found rather surprising when you consider Apple have the best downloadable video distribution service out there in the form of the iTunes Music (Media) Store ;) How many people here would be prepared to pay US$1.99 (or AUD$3.39, or what the local price) for a downloadable version of various Apple Keynotes, just hours after the event itself. Sure the quality from iTMS would be lower then the streamed versions - I believe the streamed versions are now available in HD while the standard format for iTMS is 320x240 pixels. Not the best but acceptable. Perhaps if we all wrote to Apple via their Feedback Form found at http://www.apple.com/feedback/itunes.html (which can also be accessed from the Provide Feedback option under the iTunes menu in iTunes itself) requesting they add the keynotes to the iTMS they may actually do this. I have just done so, setting the Request Type of Request Artist and suggested that artist be Steve Jobs and stating that many people on various mailing lists and web forum often enquire about obtaining a downloadable version. If YOU would be interested in getting a downloadable version of the Apple Keynotes (this one or even future ones) then please take a few minutes to use the Request Music feedback form and we may just get what we want ;) -- Nicholas Pyers, Macintosh User Group Resources email: [EMAIL PROTECTED] web: http://www.nicholaspyers.com/usergroups
Re: Airport
On 12/01/2006, at 9:11 PM, McCallum Malcolm wrote: Like Houston I have a problem :-( I have a Netgear wireless router DG834G and an Airport Express which cover my house for the laptops :-) They have worked well esp. since I got the netgear router. Now all of a sudden neither appear to be working, maybe because I HAVE 10.4.4In the place of the usual airport bars I have a tree with greyed out bars behind.Can someone make any sensible suggestions. Both laptops have the same thing and both work on ethernet. JiWire shows nothing in the way of signal. BTW cant wait to see my mates who mocked me when I bought appleshares :-) Mac Hi Mac, Have you tried restarting your Router Airport Express? Check is the AirPort port selected. Open System Preferences, then click Network. Choose Active Network Ports from the Show pop-up menu, then make sure the AirPort checkbox is selected. Also Open Internet Connect and make sure AirPort is turned on. Restart your base station by unplugging and plugging in, then try the connection again. If you are still unable to connect go to : Applications Utilities Airport Admin Utility Highlight your Network Click 'Configure' Click 'Restart' Cheers, Ronni
RSS Feeds
Sorry -I'm a bit slow on the uptake. To view and subscribe? to RSS Feeds: Do I need a separate application (Newsreader) If so what do you recommend? Free? Can I not do it through Safari or Firefox? I am on 10.3.9 ta Rod -- Rod BLITVICH Head of Learning Technologies Balcatta Senior High School Apple Educator of Excellence 2002 - 2003 Amy and Sam's Dad [EMAIL PROTECTED]0409 681 256 http://blittosblog.blogspot.com/ http://www.apple.com.au/education/hed/products/ibook/balcatta.html I just got lost in thought. It was unfamiliar territory.
Re: Software Update Dilemma
On 12/01/2006, at 9:14 AM, Reg Whitely wrote: Thanks Ronni, Peter and others I think my biggest dilemma is that I can't read, or do Maths! What's the difference between 6 and 7 you may well ask! Ok I already had QT Pro 7.0.3, and the update to 7.0.4 has brought no problems. I'm still registered for Pro. For some silly reason I thought I had QT 6 and that this was a new major release. (Intel on the brain?) This may have been exacerbated by the inclusion of a statement in the notes for QT on Software Update that QT Pro users will need to purchase a new code. The note fails to point out that this can be ignored if you already have QT 7. Apple could make this more clear. The current wording is certainly confusing if read quickly. Now not to panic until Quicktime 8 comes along. I've downloaded and installed iTunes through software updater, also 10.4.4 and PowerBook battery update. All seems to be working Ok. You might like to read this though, brought to my attention on the maced list: iTunes has spyware? http://www.macworld.com/weblogs/editors/2006/01/ministore/ index.php?lsrc=mw rss The current version of this carries a disclaimer that the original article was in error. -- Peter HinchliffeApwin Computer Services FileMaker Pro Solutions Developer Perth, Western Australia Phone (618) 9332 6482Fax (618) 9332 0913 Mac because I prefer it -- Windows because I have to.
Re: Airport
I think Ronda's suggestion will probably work. If not, you can try another approach which is to run a permissions repair. If that still doesn't work. download the combo update from apple. http://wsidecar.apple.com/cgi-bin/nph-reg3rdpty1.pl/product=09364cat=1platform=osxmethod=sa/MacOSXUpdateCombo10.4.4.dmg (120 megs) and remove the reciepts from previous updates related to the OS in /Library/reciepts. Install the combo update and run a permissions repair. I've found that some problems can be fixed, simply by installing a combo update over the current system and running a permissions repair. I noticed a problem with airport that this seemed to fix in 10.4.2 Mike --- Ronda Brown [EMAIL PROTECTED] wrote: On 12/01/2006, at 9:11 PM, McCallum Malcolm wrote: Like Houston I have a problem :-( I have a Netgear wireless router DG834G and an Airport Express which cover my house for the laptops :-) They have worked well esp. since I got the netgear router. Now all of a sudden neither appear to be working, maybe because I HAVE 10.4.4In the place of the usual airport bars I have a tree with greyed out bars behind.Can someone make any sensible suggestions. Both laptops have the same thing and both work on ethernet. JiWire shows nothing in the way of signal. BTW cant wait to see my mates who mocked me when I bought appleshares :-) Mac Hi Mac, Have you tried restarting your Router Airport Express? Check is the AirPort port selected. Open System Preferences, then click Network. Choose Active Network Ports from the Show pop-up menu, then make sure the AirPort checkbox is selected. Also Open Internet Connect and make sure AirPort is turned on. Restart your base station by unplugging and plugging in, then try the connection again. If you are still unable to connect go to : Applications Utilities Airport Admin Utility Highlight your Network Click 'Configure' Click 'Restart' Cheers, Ronni -- The WA Macintosh User Group Mailing List -- Archives - http://www.wamug.org.au/mailinglist/archives.shtml Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml Unsubscribe - mailto:[EMAIL PROTECTED] WAMUG is powered by Stalker CommuniGatePro __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: RSS Feeds
On 13/01/2006, at 8:16 AM, Rod Blitvich wrote: To view and subscribe? to RSS Feeds: Do I need a separate application (Newsreader) not necessarily If so what do you recommend? Free? Try Netnewswire lite http://ranchero.com/netnewswire/ Can I not do it through Safari or Firefox? I am on 10.3.9 I belive you need 10.4 to do RSS with Safari HTH Stew
Re: snailmail thingy
Use Appleworks database and its custom labels facility. Merv At 4:57 PM +0800 12/1/06, Paul Weaver wrote: Does anyone know of a really simple OSX freeware ap. to generate less than 40 postal address labels? (For a school music group.) Kind regards, Paul. -- Dr Paul R. Weaver http://www.livejournal.com/users/fremantlebiz/calendar -- The WA Macintosh User Group Mailing List -- Archives - http://www.wamug.org.au/mailinglist/archives.shtml Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml Unsubscribe - mailto:[EMAIL PROTECTED] WAMUG is powered by Stalker CommuniGatePro -- Science teaches that we must see in order to believe, but we must also believe in order to see.
Re: OS X 10.4.3 or 4.4
On 12/01/2006, at 6:53 PM, Chris Burton wrote: Hi Muggers On the apple site for downloads it has 10.4.4 for download and says it requires 10.4.3 to do it. I am running 10.4.2 and have tried 4 times to download 4.3 with the files stopping about half way and chewing up my broadband account. Is there a local site I can get this update that is stable? (G5 dual 2ghz). Is there a 4.4 combo that does it? I would rather get the file download as I have a couple of machines to update including powerbooks the macworld show was just great. These new processors sound really grunty and all the new updates to ilife and iwork are great too. There is a combo updater available at http://www.apple.com/support/downloads/macosxupdate1044combo.html It's pretty hefty at 120Mb -- Peter HinchliffeApwin Computer Services FileMaker Pro Solutions Developer Perth, Western Australia Phone (618) 9332 6482Fax (618) 9332 0913 Mac because I prefer it -- Windows because I have to.
OT (humor) The Office for IT workers?
from the writer of Father Ted and Black Books could be interesting. or it could be too painfully real - like This is Spinal Tap was to rock musicians http://www.channel4.com/entertainment/tv/microsites/I/itcrowd/ -- ~ Mark Secker Computer Support Officer ph# 61-8-6488 1855 (ECEL) mailto:[EMAIL PROTECTED] University of Western Australia - CRICOS Provider No. 00126G ~ It takes an idiot to do cool things that's why it's cool - Haruhara Haruka (FLCL) Ubi fumus, ibi fumus
Re: macbooks firewire 400 only?
On 11/01/2006, at 11:35 AM, Jude wrote: Hi all Does anyone have any insights into why the new Macbooks ship with firewire 400 only? I would suspect because DV cameras are still in the Firewire 400 mode and the dominant OS still not taking up Firewire 800. P2 memory Sticks seem to be the next generation for transferring digitised media (Although the PCMCIA has gone too?). Also with SATA drives being the major external mode of operation for above said OS with external HD and faster transfer speeds. I do believe although not confirmed, but their are Express card devices that will run SATA at it's full potential so Raids etc can be configured and Firewire 800 could be initialised via same process although manufacturer I spoke to said SATA is more viable than Firewire 800. This machine looks to be an excellent mobile editing system, but.. no firewire 800? Is there something new or coming up that I don't know about here..? Powerbooks have always been, and still are a great editing system. Maybe in the next format of MacBooks with larger screens it could be offered although as suggested above SATA for HardDrives could be a better and cheaper option. cheers Jude One small point I have noticed which could be more detrimental to Digital Professionals is the PCMCIA adapter slot is gone. Cheers! `Rob...
Re: OS X 10.4.3 or 4.4
On 13/01/2006, at 10:47 AM, Chris Burton wrote: Hi Pete Thanks very much for the info pete. I also checked with the guys at Joondalup and they said the combo version usually arrives a few days after the straight update version. Nick also said if I use software update, I can choose to download and keep the software package as well which would save me doing 3 updates! It is in the 'update' menu of software update! A nice tip to use in future that I didnt know about. Yep. I use this option all the time (at least all the times I remember to :-) ). How much nicer it would be if it could be made a default option by clicking something in System Preferences! BTW - the downloads arrive in /Library/Packages... Cheers, Peter
Keyboard backlighting
Even though I have illuminate keyboard in low light conditions turned in in the system preferences my backlighting is not working. It was happening prior to updating to 10.4.4 Any ideas please? 15 PowerBook 1.5GHz 1G RAM 10.4.4 thanks and Best wishes edward
Windows Media Player R.I.P.
Micro$oft have stopped development on Windows Media Player for the Mac, according to this article: http://www.techweb.com/wire/software/175804019 Instead, users are re-directed to a freeware version of Flip4Mac. All I can say is... What A Relief! As far as I could see, M$ had to either improve the darn thing out of all sight, or kill it completely. I think death was the kinder option. Flip4Mac is a fantastic alternative, especially if you have Quicktime Pro. -- Peter HinchliffeApwin Computer Services FileMaker Pro Solutions Developer Perth, Western Australia Phone (618) 9332 6482Fax (618) 9332 0913 Mac because I prefer it -- Windows because I have to.
Re: macbooks firewire 400 only?
Powerbooks have always been, and still are a great editing system. Straight cutting sure, but not if you're doing any kind of complex compositing or anything higher than DV - it just didn't have the grunt (or space) to be a professional machine. Maybe in the next format of MacBooks with larger screens it could be offered although as suggested above SATA for HardDrives could be a better and cheaper option. SATA RAIDs would be great. And yeah - more screen space, but then, the whole point of the laptop is its portability, not its power, or comfort levels as a day-to-day rig.
Re: macbooks firewire 400 only?
I think the articles in Apple Pro like http://www.apple.com/pro/video/niles/ summed it up. laptops for rough cuts and daily rushes (which may be enough for release in some situations) but desktop for final cut release work Powerbooks have always been, and still are a great editing system. Straight cutting sure, but not if you're doing any kind of complex compositing or anything higher than DV - it just didn't have the grunt (or space) to be a professional machine. Maybe in the next format of MacBooks with larger screens it could be offered although as suggested above SATA for HardDrives could be a better and cheaper option. SATA RAIDs would be great. And yeah - more screen space, but then, the whole point of the laptop is its portability, not its power, or comfort levels as a day-to-day rig. -- The WA Macintosh User Group Mailing List -- Archives - http://www.wamug.org.au/mailinglist/archives.shtml Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml Unsubscribe - mailto:[EMAIL PROTECTED] WAMUG is powered by Stalker CommuniGatePro -- ~ Mark Secker Computer Support Officer ph# 61-8-6488 1855 (ECEL) mailto:[EMAIL PROTECTED] University of Western Australia - CRICOS Provider No. 00126G ~ It takes an idiot to do cool things that's why it's cool - Haruhara Haruka (FLCL) Ubi fumus, ibi fumus
Tiger Networking
Many thanks to Craig, Ronda, Greg others who passed on so much info on the recent networking for idiots thread - I now have a much clearer idea on how this all works (I think/hope!). I have now come across another area where Tiger seems to behave differently - it may be my settings but I think it is more that some networking features have been changed in Tiger. The problem came when I tried to connect to my G4 400MHz Ti Powerbook, running OS 9.1. Whilst my G4 iMac (running 10.2.8) would connect OK the new G5 iMac (running 10.4.3) would see the powerbook but attempting to connect would give the error message Connection failed This file server uses an incompatible version of the AFP protocol. You cannot connect to it.. I should say that I normally have my powerbook set-up to access the internet via dial-up so TCP/IP is set to connect via PPP. Previously with my G4 iMac I had found that the iMac could see and connect to the powerbook but although the powerbook could see the iMac it would not connect to it. After much searching of the Apple knowledge base and other sites, I found that the reason was that the although the OSX iMac could connect to shared volumes via Appletalk, it would only allow access to it's shared volumes via TCP/IP. I found that if I set TCP/IP on the powerbook to connect via ethernet (and set up the addresses manually) I could connect to the iMac - though then I could not connect to the internet! I have lived with this by having two locations set up on the powerbook - one for internet with TCP/IP set to PPP and one for two-way file sharing with TCP/IP set to ethernet. Whilst annoying, this has not been too bad because for most purposes I could leave the powebook set for internet and do any file management from the iMac. On the rare occasions when I needed to mount the iMac shared volume on the Powerbook (rather than the other way around) I would temporarily change locations on the Powerbook. However given the error message I get when trying to access the powerbook from the new G5 iMac, Tiger no longer can access shared volumes over Appletalk - although you can apparently turn Appletalk on off ??! When I changed TCP/IP on the powerbook to connect via Ethernet, Tiger would then connect and mount the shared volume. Could anyone confirm that my understanding is correct here - or do I just need to alter some setting somewhare to allow Tiger to connect via Appletalk while the powerbook is set up with TCP/IP to connect via PPP as I can do with Jaguar. Cheers Neil -- Neil R. Houghton Albany, Western Australia Tel: +61 8 9841 6063 Fax: +61 8 9841 6137 Email: [EMAIL PROTECTED]
Re: Keyboard backlighting
Hi On 13/01/06, Edward Arrowsmith [EMAIL PROTECTED] wrote: Even though I have illuminate keyboard in low light conditions turned in in the system preferences my backlighting is not working. It was happening prior to updating to 10.4.4 Have you tried any obvious measures yet, like checking the backlight brightness? Perhaps it is possible that the brightness can be zero despite the illuminate keybaord option? Perhaps you could induce low light conditions (e.g., by covering both the left and right light sensors / speaker grilles with books), then you can use your keyboard buttons to adjust your backlight brightness and see if that makes a difference or not?
Re: Tiger Networking
On 13/01/2006, at 1:00 PM, Neil Houghton wrote: Many thanks to Craig, Ronda, Greg others who passed on so much info on the recent networking for idiots thread - I now have a much clearer idea on how this all works (I think/hope!). I have now come across another area where Tiger seems to behave differently - it may be my settings but I think it is more that some networking features have been changed in Tiger. The problem came when I tried to connect to my G4 400MHz Ti Powerbook, running OS 9.1. Whilst my G4 iMac (running 10.2.8) would connect OK the new G5 iMac (running 10.4.3) would see the powerbook but attempting to connect would give the error message Connection failed This file server uses an incompatible version of the AFP protocol. You cannot connect to it.. I should say that I normally have my powerbook set-up to access the internet via dial-up so TCP/IP is set to connect via PPP. Previously with my G4 iMac I had found that the iMac could see and connect to the powerbook but although the powerbook could see the iMac it would not connect to it. After much searching of the Apple knowledge base and other sites, I found that the reason was that the although the OSX iMac could connect to shared volumes via Appletalk, it would only allow access to it's shared volumes via TCP/IP. I found that if I set TCP/IP on the powerbook to connect via ethernet (and set up the addresses manually) I could connect to the iMac - though then I could not connect to the internet! I have lived with this by having two locations set up on the powerbook - one for internet with TCP/IP set to PPP and one for two-way file sharing with TCP/IP set to ethernet. Whilst annoying, this has not been too bad because for most purposes I could leave the powebook set for internet and do any file management from the iMac. On the rare occasions when I needed to mount the iMac shared volume on the Powerbook (rather than the other way around) I would temporarily change locations on the Powerbook. However given the error message I get when trying to access the powerbook from the new G5 iMac, Tiger no longer can access shared volumes over Appletalk - although you can apparently turn Appletalk on off ??! When I changed TCP/IP on the powerbook to connect via Ethernet, Tiger would then connect and mount the shared volume. Could anyone confirm that my understanding is correct here - or do I just need to alter some setting somewhare to allow Tiger to connect via Appletalk while the powerbook is set up with TCP/IP to connect via PPP as I can do with Jaguar. Hi Neil, From what I understand about file sharing between different OS': Mac OS 9, and Mac OS X 10.1 to 10.3.9 support file sharing (AFP) connections over AppleTalk. However, Mac OS X versions 10.0 to 10.0.4 and 10.4 and later can only connect to AppleShare over TCP/IP. Mac OS 9 and Mac OS X can both connect over TCP/IP without AppleTalk. Mac OS X 10.4 and later don't support Personal File Sharing (or other AFP) over Appletalk, though by initiating the connection from the opposite direction you could still achieve an IP connection from a Mac OS 9 computer to a sharing Mac OS X computer. The Network preference pane in Mac OS X 10.4 and later still offers the AppleTalk checkbox, but it is for browsing AppleTalk-advertised resources and zones. The subsequent connection must be over TCP/IP. Hope I haven't confused you more. Cheers, Ronni
Re: Tiger Networking
Hi again Neil, On 13/01/2006, at 1:00 PM, Neil Houghton wrote: The problem came when I tried to connect to my G4 400MHz Ti Powerbook, running OS 9.1. Whilst my G4 iMac (running 10.2.8) would connect OK the new G5 iMac (running 10.4.3) would see the powerbook but attempting to connect would give the error message Connection failed This file server uses an incompatible version of the AFP protocol. You cannot connect to it.. Following up my previous email: If you try to connect to an AppleTalk-only AFP server from a Mac OS X 10.4 Tiger computer, this message will appear: Connection failed. This file server uses an incompatible version of the AFP protocol. You cannot connect to it. This happens because Tiger no longer supports connecting to AFP over the AppleTalk protocol. As a solution, enable the TCP/IP protocol on the AFP server if it offers this option. If no TCP/IP option is available, connect to the Tiger computer from the computer that is the AppleTalk-only AFP server (instead of trying to connect from the Tiger computer to connect to the older computer). This method works because AppleShare client software on the older computer can connect to a Tiger computer over TCP/IP, even if it can't offer service over TCP/IP. Cheers, Ronni
Re: Windows Media Player R.I.P.
On 13/01/2006, at 11:55 AM, Peter Hinchliffe wrote: Micro$oft have stopped development on Windows Media Player for the Mac, according to this article: http://www.techweb.com/wire/software/175804019 Instead, users are re-directed to a freeware version of Flip4Mac. All I can say is... What A Relief! Now all we need is for Real to follow suit and all will be good! - Matt (BTW Peter, come and grab your eskys)
Re: Windows Media Player R.I.P.
G'day all I was foolish enough to download and install. Now QuickTime constantly crashes. Don't go there! mike moore On 13/01/2006, at 3:22 PM, Matthew Healey wrote: On 13/01/2006, at 11:55 AM, Peter Hinchliffe wrote: Micro$oft have stopped development on Windows Media Player for the Mac, according to this article: http://www.techweb.com/wire/software/175804019 Instead, users are re-directed to a freeware version of Flip4Mac. All I can say is... What A Relief! Now all we need is for Real to follow suit and all will be good! - Matt (BTW Peter, come and grab your eskys) -- The WA Macintosh User Group Mailing List -- Archives - http://www.wamug.org.au/mailinglist/archives.shtml Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml Unsubscribe - mailto:[EMAIL PROTECTED] WAMUG is powered by Stalker CommuniGatePro
Re: Windows Media Player R.I.P.
Try this Mike http://www.flip4mac.com/faqs_wmv.htm#1 I upgraded to QuickTime v7.0.4 and now QuickTime crashes when I use Flip4Mac WMV There is a compatibility issue with QuickTime v 7.0.4. Please download Flip4Mac WMV v2.0.1 now. This version resolves the compatibility issue with QuickTime v7.0.4. Reg On 13 Jan 2006, at 5:18pm, Mike MOORE wrote: G'day all I was foolish enough to download and install. Now QuickTime constantly crashes. Don't go there! mike moore
Re: Windows Media Player R.I.P.
Installed Flip4Mac 'Windows Media Components for Quicktime' on OSX10.4.4 Quicktime 7.0.4 and no problems here. Ronni On 13/01/2006, at 5:18 PM, Mike MOORE wrote: G'day all I was foolish enough to download and install. Now QuickTime constantly crashes. Don't go there! mike moore On 13/01/2006, at 3:22 PM, Matthew Healey wrote: On 13/01/2006, at 11:55 AM, Peter Hinchliffe wrote: Micro$oft have stopped development on Windows Media Player for the Mac, according to this article: http://www.techweb.com/wire/software/175804019 Instead, users are re-directed to a freeware version of Flip4Mac. All I can say is... What A Relief! Now all we need is for Real to follow suit and all will be good! - Matt (BTW Peter, come and grab your eskys) -- The WA Macintosh User Group Mailing List -- Archives - http://www.wamug.org.au/mailinglist/archives.shtml Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml Unsubscribe - mailto:[EMAIL PROTECTED] WAMUG is powered by Stalker CommuniGatePro -- The WA Macintosh User Group Mailing List -- Archives - http://www.wamug.org.au/mailinglist/archives.shtml Guidelines - http://www.wamug.org.au/mailinglist/guidelines.shtml Unsubscribe - mailto:[EMAIL PROTECTED] WAMUG is powered by Stalker CommuniGatePro
24 hour time in excel
Hi waymuggers I have a time calculation problem I've being trying to resolve for the past 4 hours, and my brain now hurts a lot!. I have two excel files filled with 9000 records from a gps in which the time was set to be 8 hours behind. If I add 8 hrs to those records with the time after midnight (eg 0:00:25) for example, starts the day at 8:00:25. But the records with time prior to midnight (eg 22:15:25 ends up at 30:15:25). For the life of me I cant figure it out, even after doing some googling. Can someone with good brain cells please help me? kindest regards chris
Re: 24 hour time in excel
Hi Chris, On 13/01/06, Chris Burton [EMAIL PROTECTED] wrote: If I add 8 hrs to those records with the time after midnight (eg 0:00:25) for example, starts the day at 8:00:25. But the records with time prior to midnight (eg 22:15:25 ends up at 30:15:25). I am not familiar with how Excel handles dates, but two general solutions come to mind. One is to see if Excel can be told that the dates are in UTC or GMT time so that it can do the calculation itself. Alternatively, you know that the hour must be between 0 and 23, thus it adheres to the function MOD(original_hour + 8, 24).
Re: 24 hour time in excel
Hi Chris All times are stored as fractions of a day. So you need to do as James suggested (if you have hours separately stored) or do something like Assuming you have orig time in Col A, time + 8:00 in Col B, make a col C with the following formula... =IF(B1=1,B1-1,B1) (to subtract 1 day off when the clock ticks over Or you could combine with your timezone correction calcs woz On 13/01/2006, at 6:24 PM, Chris Burton wrote: Hi waymuggers I have a time calculation problem I've being trying to resolve for the past 4 hours, and my brain now hurts a lot!. I have two excel files filled with 9000 records from a gps in which the time was set to be 8 hours behind. If I add 8 hrs to those records with the time after midnight (eg 0:00:25) for example, starts the day at 8:00:25. But the records with time prior to midnight (eg 22:15:25 ends up at 30:15:25). For the life of me I cant figure it out, even after doing some googling. Can someone with good brain cells please help me? kindest regards chris -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Warren Jones http:// homepage.mac.com/warrenj/ Perth, Western Australia
