🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: aus.mathematics
Article #143

Need help with time maths

#143
From: Clinton M James
Date: Mon, 19 Mar 2007 14:16
32 lines
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-mail

Show 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