Clinton M James
2007-03-19 14:16:45 UTC
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
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
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
help is appreciated