missij99360262
Community profile missij99360262 Level 1
Job title here
Location here
0 BADGES
Level 1

Level 1

Learn more
Joined the community 24-04-2015 7:03:07 AM
Offline
Top badges earned by missij99360262
Customize the badges you want to showcase on your profile
Re: Not sure why this isn't calculating..
Avatar
Level 1
missij99360262
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile
missij99360262
- Adobe LiveCycle
Thank you!On Mon, May 11, 2015 at 4:41 PM, jasotastic81

Views

83

Likes

0

Replies

0
Not sure why this isn't calculating..
Avatar
Level 1
missij99360262
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile
missij99360262
- Adobe LiveCycle
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

352

Likes

0

Replies

2