since ‎24-04-2015
‎10-12-2019
missij99360262
Level 1
Re: Not sure why this isn't calculating..
Avatar

missij99360262

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

Views

47

Likes

0

Replies

0
Not sure why this isn't calculating..
Avatar

missij99360262

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

314

Likes

0

Replies

2