Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Gary_D__Cooper
Gary_D__Cooper
Offline

Badges

Badges
4

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts & Comments

Posts & Comments
6

Discussions

Discussions
0

Questions

Questions
1

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by Gary_D__Cooper
Customize the badges you want to showcase on your profile
Re: OT Calculation - Adobe LiveCycle 10-04-2014
Any thoughts?

Views

130

Likes

0

Replies

0
Re: OT Calculation - Adobe LiveCycle 08-04-2014
I have done what you've suggested and the input fields are set to time with a format of time{h:MM A}. It seems to just not calculate with this.var fullTime = 0 if (Table1.Row4.Cell2 ne null and Table1.Row5.Cell2 ne null) then if (Time2Num(Table1.Row4.Cell2.formattedValue, "HH:MM A") lt Time2Num(Table1.Row5.Cell2.formattedValue, "HH:MM A")) then fullTime = Abs(Time2Num(Table1.Row4.Cell2.formattedValue, "HH:MM A") - Time2Num(Table1.Row5.Cell2.formattedValue, "HH:MM A")) / (60 * 60 * 1000) else ful...

Views

131

Likes

0

Replies

0
Re: OT Calculation - Adobe LiveCycle 08-04-2014
I've noticed that it might have to deal with the seconds. When you try to do calculations they need the seconds for it to work, but when a user enters 8:00 AM there's no way to add the 00 to the end of the 8:00. To do calculations you need it in the format of 8:00:00 AM.

Views

129

Likes

0

Replies

0
Re: OT Calculation - Adobe LiveCycle 07-04-2014
Maybe if I gave you an example it might help.Start 8:00 AMStop Start Lunch Start 12:00 PMLunch End 1:00 PMStop Start End 5:00 PMTotal Hours 8.0ORStart 7:00 AMStop Start Lunch Start 12:00 PMLunch End 1:00 PMStop Start End 6:00 PMTotal Hours 10.0

Views

129

Likes

0

Replies

0
Re: OT Calculation - Adobe LiveCycle 07-04-2014
I tried to implement what you suggested, but now it just constantly shows a 0. Here is what I added to my FormCalc;var fullTime = 0if (Table1.Row4.Cell2 ne null and Table1.Row5.Cell2 ne null) then if (Time2Num(Table1.Row4.Cell2.formattedValue, "HH:MM") lt Time2Num(Table1.Row5.Cell2.formattedValue, "HH:MM")) then fullTime = Abs(Time2Num(Table1.Row4.Cell2.formattedValue, "HH:MM") - Time2Num(Table1.Row5.Cell2.formattedValue, "HH:MM")) / (60 * 60 * 1000) else fullTime = 24 - Abs(Time2Num(Table1.Row5...

Views

130

Likes

0

Replies

0
OT Calculation - Adobe LiveCycle 07-04-2014
I've got a Form where I have a table with 8 fields and 1 field that calculates total hours worked. Each field the user needs to enter a valid time 8:00 AM or 1700, which will be converted to 5:00 PM. I'm trying to come up with a FormCalc formula that will give me the total hours worked.This is what I have so far; (Row5.Cell2-Row4.Cell2+Row7.Cell2-Row6.Cell2+Row9.Cell2-Row8.Cell2+Row11.Cell2-Row10.Cell2)*1440/60The fields are as follows:Start Stop Start Lunch Start Lunch End Stop Start End Total ...

Views

868

Likes

0

Replies

8