Hi gang!

First off, for all those who've sent solution ideas in the past... THANK YOU! The dbase works GREAT!

Now I'm trying to calculate total time worked for various employees. The report lists every job the employee did (within date parameters), the time each job was started and finished, and a "total time spent on the job." I have to sum the "total times" to come up with an overall length of "Time On Task" for the date period specified (sometimes the user will ask for data for a single day.. sometimes for an entire week, month, quarter, etc...). The problem I'm running into is converting the decimal number to actual "clock" hours:minutes. I've noticed that the clock hours sum correctly... e.g., an employee worked 30+hours for a date period, and the Total Time field (summed) shows a number such as 30.235467 (you get the idea). What I need to do is convert that decimal number to display as hh:nn, with the hours intact (even beyond 24 hours!) and the minutes appropriately displayed as minutes, not decimal parts of an hour.

I know I've seen the solution to this issue SOMEWHERE, but for the life of me can't remember where!!

Best wishes, and happy holidays!
Scott

Scott;

I am sorking on something similar right now. It is actually better to keep rack of time worked in increments of 15 minutes. Then you can just have resources enter their time as .5, .25, 1.75.

Then you can do easier math. there is no way that someone works 1.755468 hours anyway it is 1.75.

Changing 30.235467 to actual clock time may not be completly possible.





Sal

This article may offer some assistance

http://support.microsoft.com/?kbid=237958

are you gonna do this converion in the database??

If you are doing it in a programming language like java or C#.
You can easily convert the minutes to not be a apart of the hor decimals. If you have solved in the database, can you let me know how you did it?

StreetSweaper

I guess I'm not seeing the problem. If someone works 30.235467 hours then that equals 30 hours and ROUND(0.235467 * 60, 0) or 14 minutes.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Hi! THe problem is my manager wants to see the total time as hh:nn, not xx.xxxxxxxxx I get the total just fine, but have to convert the numbers to the right of the decimal point to get minutes. You mentioned "ROUND" in your reply.... I'm not familiar with that... How would I write language that would take the numbers to the right of the decimal and convert them (x*60,0)?

Thanks!

To get the decimal part of a number, you can just subtract the integer part - eg:

Dim dblVar1 as Double
Dim dblVar2 as Double
dblVar1 = 6.4343
dblVar2=dblVar1-Int(dblVar1)

So dblVar2=0.4343

or - to put it another way:
X = 6.42345 - Int(6.42345)
means X = 0.42345



I am a loud man with a very large hat. This means I am in charge

[quote]Originally posted by Steven
 To get the decimal part of a number, you can just subtract the integer part - eg:

Dim dblVar1 as Double
Dim dblVar2 as Double
dblVar1 = 6.4343
dblVar2=dblVar1-Int(dblVar1)

So dblVar2=0.4343

or - to put it another way:
X = 6.42345 - Int(6.42345)
means X = 0.42345

Steven: Sounds great... but I'm a relative "newbie". Could you give an example how/where I would place that little tidbit of code? We need to be able to calculate this in a report, on the fly. How do I name the variables? After the decimal part has been stripped away from the integer, how do I convert it to hh:nn? Any and all ideas/solutions are welcome here in FRIGID New York!

Scott

Well - If you're just wanting to display it on the form as an integer, you could simply have a text box with the control source being =Int([YourField])
Or, if you need to do some calculations with it, you would probably do it in the record source (i.e. the query), where you'd basically just do the same sort of thing

I am a loud man with a very large hat. This means I am in charge