More Time Calculation Questions

[hjyon]

Hello,

For those of you who don't know. Last week I began building our eTime system in Alpha 5 from Caspio. Anyhow, I have come quite a ways, thanks to the great help of those in the forum.

I have the timesheet part working, but not how I would like it to work. I have fields for each day of the week that include: TimeIn|t, TimeOut|t, Break, TotalHrs|n. I then have a field for GrandTotalHrs|n, that should total the entire week's hours. However, I am having issues with the GrandTotalHrs to total/calculate. I have it set up as a numeric field, but I am not entirely sure this is the right data choice. Any suggestions.


My next question is what i need is for the user to entire their time in military time and then allowing it total. Currently the set up is (and this if for Monday)

dim mtimein as y=convert_type(e.datasubmitted.MonTimeIn,"Y")
dim mdatein as a d = convert_type(e.datasubmitted.MonTimeIn,"Y")
dim mtimeout as y = convert_type(e.datasubmitted.MonTimeOut,"Y")
dim mdateout as y = convert_type(e.datasubmitted.MonTimeOut,"D")

e._set.MonTotalHrs.value=totime((mtimeout+mdateout)-(mdatein+mtimein),1,0)

(As a side note I have not figured out how to subtract out Break time, but I am not as worried about that for the moment)

Anyhow, the above Code works great. When the user focuses on the TimeIn field on Monday, a pop-up calendar/time appears and they can select the date/time. But this is just not simple enough for the user. All I want is for the user to type in military time their time in and their time out, select their break time, and for it to total, accordingly.


I need the date to be able to calculate the time correctly, because we have employees that work evening/night shifts. So they may clock in at 8pm and clock out at 6am. So, I can't just do a simple short time, that won't calculate correctly.

At this point I am at a loss as to how to properly code this and to make it as simple as possible for the user.

Please if anyone can offer some guidance into this, I would once again more than appreciate it!

[madtowng]

Re: More Time Calculation Questions

Hi Holly,

A lot of this depends on how you are really doing this.
If this is like a paper time card, that the user can do at the end of the week, writing in his/her days work, time in, and time, you need to provide space for the user to supply the date and time data in your application.


If you want to do this more like a time clock, where the user "punches" the clock in sequential order, you can make data entry real easy on the user.


The bottom line is you must determine if the user is going to provide all the data, or if you are going to "assume" some of it. Once you have that figured out, the rest goes pretty easy.