Calculating Time

[Flo1289]

Hi, I posted last week and I am still having trouble. Is there anyone out there that can give me step by step instructions on how to accomplish the following in Alpha Five V11 for a server app.

I need to set up a dialog box with the following fields:

Employee
Job Ticket

"Repeating Section"

Date (this is a date field)
Begining_Time (this is a time field)
Ending_Time (this is a time field)
Running_Total (this is a numberic field)

"and then back to not a repeating section"

Total_Hours (numeric field)

I need to know how to get the Running_Total field to display the Begining_Time - the Ending_Time in a numberic field such as the following. The person works from 8:00 to 5:15 I would want the Running Total to show 9.15. This would be 9 hours and 15 min. The date does not matter and does not need to be included in the calculations. The Total_Hours at the bottom would be all of the running totals added together, but I think I know how to do that. I just need to know how to convert the time fields into the running total.

I am new to alpha and new to coding so it would be so awesome if someone could help me with step by step instructions. Thank you so much. There was a man last week that gave me some instructions but I really can not understand them. I do appreciate his help but I do not understand the coding and do not know how to make it work.

Thank you.

[iRadiate]

Re: Calculating Time

You should be able to simply subtract one time from the other. Manipulate the formatting to make it give you what you need.

time.JPG

Stephen

[Flo1289]

Re: Calculating Time

I'm sorry but I don' t know how to do this. I really need step by step instructions on how to accomplish this.

Thanks

[Flo1289]

Re: Calculating Time

I put the code into the interactive window but I don't know what to do next. I have a feeling that there is a very simple solution to this problem but it is just outside of my reach. It is very frustrating.

I appreciate very much anyone who can help.

[madtowng]

Re: Calculating Time

dim workday as d
dim beginning_time as y
dim ending_time as y
dim running_total as n

workday = {10/10/2012}
beginning_time = {08:00}
ending_time = {17:15}
running_total = ending_time - beginning_time
? totime(running_total,1,0)
= "9:15"

[hjyon]

Re: Calculating Time

Hello,

I too am building a timecard database to keep track of employees hours. And am also running to issues with the coding with Alpha to display the correct time.

First off I used the code as demonstrated by Gregg Schmidt, and submitted my variables within the formula, as follows:

dim TimeIn as y
dim TimeOut as y
dim Sutotalhrs as n

TimeIn = {08:00}
TimeOut = {17:15}
SuTotalHrs = TimeIn - TimeOut
? totime(sutotalhrs,1,0)
= "9:15"

It worked out fine. I am not entirely sure where this coding should go. I placed in the Xbasic Function within my Dialog. I guess my question is Now What? :D

It's in there but I don't know what I need to do next to get this function properly in a Live Preview. Suggestion?

Thanks for all the help.

[madtowng]

Re: Calculating Time

The code needs to be attached to an event (onclick, onchange, onvalidate, aftervalidate), it really depends on how you want your dialog to work.

[hjyon]

Re: Calculating Time

My guess is that I just don't know where to put this code. So I put together a whole bunch of screen shots for everyone :D
A5 - 1.png
A5 - 2.png
A5 - 3.png
A5 - 4.png
A5 - 5.png

If you want other screen shots I can provide them for all of you. Thanks again for all your assistance!

[madtowng]

Re: Calculating Time

Holly,

I would usually put this code either in a onchange event or one of the validate events.
One thing to consider is that when working with some form of submit, the values are all text, even though you defined them as something else.

Feel free to examine the sample dialog I attached.

I do a better job of explaining this on the phone (608)345-2697 and in a teamviewer session.

[hjyon]

Re: Calculating Time

Hey Gregg,

Thank you. I have looked over the sample you sent but I cannot locate where you stored the code.....?? Will you be available some time tomorrow for a chat?

-Holly

[madtowng]

Re: Calculating Time

A picture sometimes is worth much more than 1000 words.
Hopefully this one helps.
This picture show the code I use in the function, and the event it's attached to.

My schedule is very erratic.
More often than not, it's best to just call to see what I'm up to.

[hjyon]

Re: Calculating Time

Ok, so I am getting a bit closer. I found where you placed the coding in your sample and I added that same coding to my dialog and changed the variables. However, it is calculating the time as 0:00 - which is more than I was getting before :D

But here is another million dollar question.....we have employees that work night shifts. They clock in around 18:00 and clock out at 3am - how would the coding for this look in the Xbasic?

Again all of your help is MORE than appreciated!

[madtowng]

Re: Calculating Time

Pretty much the same.
Thanks to the keepers of javascript, the datetime picker is good except for the day we change to daylight saving time.
The work around is to get the date value and time value independently, and then combine them to let alpha5 do the math.
I'll use today's date, and the times you gave for the example.
Obviously, you would want to change things to work with the dialog, but this gives the general idea.

dim beg_date as d
dim beg_time as y
dim fin_date as d
dim fin_time as y

beg_date = {10/11/2012}
beg_time = {18:00}
fin_date = {10/12/2012}
fin_time = {03:00}

? totime((fin_date+fin_time)-(beg_date+beg_time),1,0)
= "9:00"

[hjyon]

Re: Calculating Time

Then obviously I would need to add Date fields....? Correct?

[madtowng]

Re: Calculating Time

Quick easy answer is yes.