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

missij99360262
missij99360262
Offline

Badges

Badges
2

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts

Posts
2

Discussions

Discussions
0

Questions

Questions
2

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by missij99360262
Customize the badges you want to showcase on your profile
Re: Not sure why this isn't calculating.. - Adobe LiveCycle 11-05-2015
Thank you!On Mon, May 11, 2015 at 4:41 PM, jasotastic81

Views

132

Likes

0

Replies

0
Not sure why this isn't calculating.. - Adobe LiveCycle 24-04-2015
Three columns...In timeOut TimeTotal Time (calculate based on in and out entered) if( HasValue(spec1b) & HasValue(spec1a) ) then// compute time difference in minutesvar TimeDiff = (Time2Num(spec1b.formattedValue, "h:MM A") - Time2Num(spec1a.formattedValue, "h:MM A")) / (1000 * 60)// truncate to hoursvar HourDiff = Floor(TimeDiff / 60)// get minutes less than 60var MinDiff = Mod(TimeDiff, 60)// build fomatted dispaly stringConcat( Format("Z9", HourDiff), ":", Format("99",MinDiff) )else// if any values missing null the outputnullendif

Views

401

Likes

0

Replies

2