We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Solved
'double' variable problem??????
Posted on 1998-08-12
I am creating a service report and the users have to enter in the time they started to the time they finished and I want to calculate the amount of hours they have worked. The method I am using seems to work the odd time but I am having trouble getting it to work all the time. I am using double variables and I am not sure if I should be using them. I am also changing the time into 24 hr clock if the starttime is larger than the endtime.
eg. starttime 11.00 endtime 2.00->14.00
This works all the time but it is when you subtract the time such as 1.15 to 2.00, you get 0. 45 but I want it to be .75 because you have worked 3/4 of an hour. I am only doing it in 15 minute intervals so I didn't think it woul be that difficult. This is how I am doin it.
if (m_hourswork==0.45) //45 minutes worked
m_hourswork=0.75;
if m_hourswork==0.15) //15 minutes worked
m_hourswork=0.25)
I do this for all 15 min intervals and every hour upto 10 hours because no one will work more than 10. The method I am using seems to work from time to time so I think it may be the 'double' varibles I am using.
Thank You for the help!!
Greatly Needed
eg. starttime 11.00 endtime 2.00->14.00
This works all the time but it is when you subtract the time such as 1.15 to 2.00, you get 0. 45 but I want it to be .75 because you have worked 3/4 of an hour. I am only doing it in 15 minute intervals so I didn't think it woul be that difficult. This is how I am doin it.
if (m_hourswork==0.45) //45 minutes worked
m_hourswork=0.75;
if m_hourswork==0.15) //15 minutes worked
m_hourswork=0.25)
I do this for all 15 min intervals and every hour upto 10 hours because no one will work more than 10. The method I am using seems to work from time to time so I think it may be the 'double' varibles I am using.
Thank You for the help!!
Greatly Needed
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
8
-
2
- +4
15 Comments
>> when you subtract the time such as 1.15 to 2.00, you get 0. 45 but I want it to be .75
You aren't being consistent in your interpretatation. If 1.00 represents an hour then 0.75 represents 3/4 of an hour or 45 minutes. That is consistent. But then 1.15 does not represent and hour an 15 minutes. It represents and hour and 15/100 of an hour, about 9 minutes. Thus
2.00 (2 hours) minus 1.15 is 0.85 or 85/100 of an hour or about 51 minutes, which is correct.
Thus you can do the math this way. The integer portion is the number of whole hours and the decimal portion is the fractional part of an hour--not the minutes. but there is a better way.
continues.
You aren't being consistent in your interpretatation. If 1.00 represents an hour then 0.75 represents 3/4 of an hour or 45 minutes. That is consistent. But then 1.15 does not represent and hour an 15 minutes. It represents and hour and 15/100 of an hour, about 9 minutes. Thus
2.00 (2 hours) minus 1.15 is 0.85 or 85/100 of an hour or about 51 minutes, which is correct.
Thus you can do the math this way. The integer portion is the number of whole hours and the decimal portion is the fractional part of an hour--not the minutes. but there is a better way.
continues.
What I would do is use a serial time for the math. a serial time represents the time using a single number, unlike hours and minutes that use seconds. The serial time scale starts at 0 at some time that you decide and then increases by one for each of the smallest units you want to measure. Thus if you need accuaracty to the minute, you might start the serial time scale at 0 at midnight, then 1 would be 1 minute after midnight (12:01 PM). Then 2 would be one minute later and so on. 1:15 PM, would then be 795 (13*60+15--more on that later) If you wanted accuracy to the second, you would dot he same thing, but each successive number indicates an additional second, not a minute.
The advantage to the serial time is that you can do math using the ordinary +,- and even * and / operators. Thus to find the difference between two serial times you can just subtract them with -.
The advantage to the serial time is that you can do math using the ordinary +,- and even * and / operators. Thus to find the difference between two serial times you can just subtract them with -.
Now to make this work, you need to be able to convert between "ordinary" times and serial times--because no one wants to enter serial times into the computer. But that is pretty easy.
Say you are doing it to the minute. Then the formula is the
T = H*60 + M
where H is the hours (on a 24 hour clock) and M is the minutes. For a second of accuracy you would use
T = H*60*60 + M *60 + S
To convert back you would use
H = Trunc(T / 60)
M = T - H*60
Let me know if you have questions.
Say you are doing it to the minute. Then the formula is the
T = H*60 + M
where H is the hours (on a 24 hour clock) and M is the minutes. For a second of accuracy you would use
T = H*60*60 + M *60 + S
To convert back you would use
H = Trunc(T / 60)
M = T - H*60
Let me know if you have questions.
More time math. I worked on an answer from 6:56 to 7:16. that is 20 minutes.
If you don't like the answer or don't understand it you should at least post a comment saying why.
If you don't like the answer or don't understand it you should at least post a comment saying why.
you can check if the function difftime is available. in combination with mk_time, you create a solution with standard functions (at least on Unix)
difftime() is always available, it's part of the C standard, which is a base document for the C++ standard.
troy, it's a dumb idea to use a floating point representation for what are inherently integer quantities. Floating point arithmetic is inexact and will allow errors to creep into your accounting. Seeing as you asked this in the C++ section, and sound like you want to roll your own, maybe you'd prefer to cook up a class which exhibits the behaviour you want using, say, an unsigned char each to store hours, minutes or seconds, and appropriate member functions to completely hide how the time is stored from the outside world. If you use MFC, examine CTime. And be a good chap, tell nietod what was up with his answer, because it looked fine to me.
difftime uses serial times. It just subtracts the two serial times and coverts the result to floating point. The mktime() procedure is used to calculate the serial times it uses. However that serial time can be used to calculate the difference in times between days. That is, it is on a much longer scale.
Also do not do this:
double hours_worked;
if (hours_worked == 0.45) {
.
}
do not use ==, and != with doubles. Because of rounding and inexactness you are likely to get some unexpected behavior
double hours_worked;
if (hours_worked == 0.45) {
.
}
do not use ==, and != with doubles. Because of rounding and inexactness you are likely to get some unexpected behavior
First don't use double with == and != as danny_pav already mentioned.
Second to calculated a hour fraction from minutes use the following formular
hour_fraction = min / 60 * 100
and the calculate the opposite direction.
min = hour_fraction *60 / 100
hope this helps.
Second to calculated a hour fraction from minutes use the following formular
hour_fraction = min / 60 * 100
and the calculate the opposite direction.
min = hour_fraction *60 / 100
hope this helps.
Featured Post
Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Templates For Beginners
Or
How To Encourage The Compiler To Work For You
Introduction
This tutorial is targeted at the reader who is, perhaps, familiar with the basics of C++ but would prefer a little slower introduction to the more ad…
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.
The viewer will be introduced to the technique of using vectors in C++. The video will cover how to define a vector, store values in the vector and retrieve data from the values stored in the vector.
Suggested Courses
Course of the Month8 days, 7 hours left to enroll
721 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.