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

purbeckphotogra
purbeckphotogra
Offline

Badges

Badges
1

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts

Posts
1

Discussions

Discussions
0

Questions

Questions
1

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by purbeckphotogra
Customize the badges you want to showcase on your profile
Re: how to roundup time calculation to nearest hour? - Adobe LiveCycle 27-06-2014
Hi,I think you calculation should be;var differenceT = Floor(( Time2Num(TimeField5.formattedValue, "HH:MM") - Time2Num(TimeField4.formattedValue, "HH:MM") + (60 * 60 * 1000) - 1 ) / (60 * 60 * 1000)) * (60 * 60 * 1000)+1That is add an hour minus one millisecond, truncate to get the hours, then multiple by hours to get back to something for Num2GMTime.RegardsBruce

Views

88

Likes

0

Replies

0