-
1. Re: Adding Time for Work Tracking
GKaiseril May 13, 2012 8:07 AM (in response to LoneAcorn)Have you made a decision about your time format?
You example is a bit confusing. If you want to enter hours and decimal fractions of an hour, then 3 hours and 30 minutes would be, so 3 hours and 30 minutes would be entered as 3:30.
Will you be using one of the time formats provided by Acrobat?
-
2. Re: Adding Time for Work Tracking
LoneAcorn May 13, 2012 8:35 AM (in response to GKaiseril)I tried both time and number. Since "time" format doesn't do calculations, I'm not sure how to add this up. If I use the "number" as my format, it doesn't add up time, as in minutes, rather just as a .3. +.3 equals.60 not 1 hour. Does that help?
-
3. Re: Adding Time for Work Tracking
GKaiseril May 13, 2012 9:25 AM (in response to LoneAcorn)If you are going to use number and decimal fractions of an hour then you need to convert minutes to hours. 15 minutes is 1/4 or 0.25 of an hour. 1 minute is 1/60 of an hour or 0.0167 hours.
Time can be computed. but you can not just add hours and minutes together, you need to convert either the hours to minutes minutes to hours, perform the addition, and then convert either the hours or minutes back to the hours and minutes format.
You still need to explain how you want the time time data entered into the form.
-
4. Re: Adding Time for Work Tracking
LoneAcorn May 13, 2012 10:57 AM (in response to GKaiseril)I am trying to prevent the end user from having to calculate or convert minutes. So for example I'd like the decimal to represent minutes.
hours spent driving: 3.25 (3hours 25 minutes), or time spend researching 3.12 (3 hours 12 minutes). The end user would enter:
3.25 and 3.12 ( my form would then calculate the total hours to be 6.37 (meaning 6 hours 37 minutes).
Hope that helps, thank you for your patience and assistance.
I know this is possible, as the person asking for this form, has several others that calculate this way, we are just trying to replicate it for a new form, and I don't have access to the person who created the original to ask ;(
-
5. Re: Adding Time for Work Tracking
GKaiseril May 13, 2012 5:00 PM (in response to LoneAcorn)OK. You want to enter the time with a decimal but not as tenths of an hour. Too much coding for custom keystroke, format, and validation.
You can can use the HH:mm format for the 24 hour time format and that would let one enter up to 23:59 or 23 hours and 59 minutes.
Sample Timesheet with Total as Decimal Hours and Hours and Minutes


