Need Help Adding Time and Creating Time Fields

[borumrm]

I have reviewed the threads related to time math but so far have not found anything that hits right on what I need. I am able to do what I need in Excel but want to include the info in Alpha but can't figure out how. Basically I record how many hours an analyst is logged into their system per month. I then calculate some stats based on the amount of time logged in.

For example I can have the following in Excel...for the two weeks shown the analyst was logged in 40 hrs 15 minutes and 30 seconds the first week and 15 hrs 30 minutes and 00 seconds the second week. I can then calculate the average time logged in per week as shown I can also sum the total time logged in for the two weeks. If I create a field in my table to try to do this what type do I use....time field does not seem to accommodate enough characters and secondly how can I replicate the math as shown here? The time entry as shown below is in the HHH:MM:SS format. This is what I would need in the data fields. Any help would be appreciated. Thanks

Week 1 Hrs 040:15:30
Week 2 Hrs 015:30:00
027:52:45 Avg

055:45:30 Sum

[Stan Mathews]

Re: Need Help Adding Time and Creating Time Fields

I have reviewed the threads related to time math but so far have not found anything that hits right on what I need. I am able to do what I need in Excel but want to include the info in Alpha but can't figure out how. Basically I record how many hours an analyst is logged into their system per month. I then calculate some stats based on the amount of time logged in.

For example I can have the following in Excel...for the two weeks shown the analyst was logged in 40 hrs 15 minutes and 30 seconds the first week and 15 hrs 30 minutes and 00 seconds the second week. I can then calculate the average time logged in per week as shown I can also sum the total time logged in for the two weeks. If I create a field in my table to try to do this what type do I use....time field does not seem to accommodate enough characters and secondly how can I replicate the math as shown here? The time entry as shown below is in the HHH:MM:SS format. This is what I would need in the data fields. Any help would be appreciated. Thanks

Week 1 Hrs 040:15:30
Week 2 Hrs 015:30:00
027:52:45 Avg

055:45:30 Sum

tm1 = "040:15:30"
tm2 = "015:30:00"
? toseconds(tm1)
= 144930.000000
? toseconds(tm1)
= 144930.000000

? toseconds(tm1)+toseconds(tm2)
= 200730.000000

? totime(toseconds(tm1)+toseconds(tm2),2,2)
= "55:45:30.00"

? totime((toseconds(tm1)+toseconds(tm2))/2,2,2)
= "27:52:45.00"

[borumrm]

Re: Need Help Adding Time and Creating Time Fields

OK.....I think I follow what you are saying but I do have one more question before I try this out....in my table what data type is this....is it a number is it character, when I enter this information into the data table I don't understand how it know which portion is hours , minutes or seconds. Can you elaborate on this a bit?

I have times like this for 10 different team members on about 6 different categories. The total time for each category is entered once a week not daily and then I compute some specific types of averages....% not ready time relative to logged in time etc.

I just dont know the data type to use for the fields that will allow the correct entry so the calcs will work correctly. THanks in advance

[Cheryl Lemire]

Re: Need Help Adding Time and Creating Time Fields

Hi Ron,

Perhaps these will help:

http://support.alphasoftware.com/alp...s/TOTIME().htm

http://support.alphasoftware.com/alp...OSECONDS().htm

Good luck and have fun!

[Stan Mathews]

Re: Need Help Adding Time and Creating Time Fields

OK.....I think I follow what you are saying but I do have one more question before I try this out....in my table what data type is this....is it a number is it character, when I enter this information into the data table I don't understand how it know which portion is hours , minutes or seconds. Can you elaborate on this a bit?

I have times like this for 10 different team members on about 6 different categories. The total time for each category is entered once a week not daily and then I compute some specific types of averages....% not ready time relative to logged in time etc.

I just dont know the data type to use for the fields that will allow the correct entry so the calcs will work correctly. THanks in advance

I think you need character fields. You could mask the data input to format it to be consistent with time values or you could have the keyers input the colons.

[Ton Spies]

Re: Need Help Adding Time and Creating Time Fields

I 've been working at time registrationapp. and defined two fields "starttime" and "stoptime" as ShortTime in a table.

Below some statements from misc UserDefinedFunctions

To get the time I use:

Dim moment as Y
moment = now()

Starting a task: I enter a record

DIM tbl as P
tbl = table.open("uren")
	tbl.enter_begin(.T.)
	             tbl.date = date()
		tbl.starttime = moment
		tbl.task = my_task
	tbl.enter_end(.T.)
tbl.close()

At the end of the task again register time and subtr stoptime-starttime

DIM tbl as P
tbl = table.open("hours")
	tbl.fetch_last() 
	if isblank("hours->stoptime")
		tbl.change_begin(.T.)
			tbl.stoptime  = moment
			tbl.totaltime = hours->stoptime-hours->starttime
		tbl.change_end(.T.)
	end if
tbl.close()

The (tbl.)totaltime you get when you subtract times is minutes.

It's just to give you an idea how it can be done.

On the last Alpha Conference Ira Perlow showed and explained the advantage of making this in UserDefined Functions.
This is my first start and it's really easy to call such functions from everywhere in the app. Ira it works well just you told us!

Goodluck

Ton