Article View: aus.mathematics
Article #143Need help with time maths
From: Clinton M James
Date: Mon, 19 Mar 2007 14:16
Date: Mon, 19 Mar 2007 14:16
32 lines
2436 bytes
2436 bytes
ive been racking my brain for one simple way to convert a time but cannot wok it out. It will be in a computer program so i have the ability to use absolute values if any part of the equation has a negatvie value, if required. ok I have a spreadsheet whereby it goes through and subtracts things, such as times So say it saw 20 weeks 15 hours 12 minutes and then saw 10 weeks 22 hours and 48 minutes, it would mius each column to make 10 weeks, -7 hours and -36 mins. Problem is i would like to convert this result back to a normal time. The program knows how many hours per week, such as 38 in the example given. I need this to apply to a variety of hours, so say i have the result but a different amount of hours to convert it over.. 35 hours, 40 hours, etc. Thing is too, the hours and mins arent always in defecit as the example is either, therefoer it will need to accommodate positive and negative results to convert it back to weeks horus mins over the specified hours and mins per week - oh thats another thing, hours per week arent always whole numbers either, it could be 37.5 hours.. I prefer to work in full weeks hours mins rather than breaking it into decimals so to protect data accuracy such as won't be occurring when any decimials have no set end - eg, 1/3 2/3 results can intefer with the accuracy, therefore working with the 3 components is preferred to changing them into 1 number (37 hours 30 mins rather than 37.5). help is appreciated
Technical Details
Message-ID:
<45fe9b50$0$17561$5a62ac22@per-qv1-newsreader-01.iinet.net.au>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed.iinet.net.au!newsfeed.iinet.net.au!per-qv1-newsstorage1.iinet.net.au!per-qv1-newsstorage1.iinet.net.au!per-qv1-newsreader-01.iinet.net.au!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 10d67e,1c2216881bdec7af,start X-Google-Attributes: gid10d67e,public X-Google-Language: ENGLISH,ASCII-7-bit Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed.iinet.net.au!newsfeed.iinet.net.au!per-qv1-newsstorage1.iinet.net.au!per-qv1-newsstorage1.iinet.net.au!per-qv1-newsreader-01.iinet.net.au!not-for-mail From: "Clinton M James" <fakeemail@yahoo.com> Newsgroups: aus.mathematics Subject: Need help with time maths Date: Tue, 20 Mar 2007 01:16:45 +1100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3028 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-RFC2646: Format=Flowed; Original Lines: 35 Message-ID: <45fe9b50$0$17561$5a62ac22@per-qv1-newsreader-01.iinet.net.au> NNTP-Posting-Host: 203.217.85.232 X-Trace: 1174313809 per-qv1-newsreader-01.iinet.net.au 17561 203.217.85.232