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

JRC91
JRC91
Offline

Badges

Badges
5

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts

Posts
6

Discussions

Discussions
0

Questions

Questions
6

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by JRC91
Customize the badges you want to showcase on your profile
Re: Time Formatting - Adobe LiveCycle 17-04-2009
Thanks again Niall - You're a Legend! (Thanks everyone else for your time, too)

Views

219

Likes

0

Replies

0
Re: Time Formatting - Adobe LiveCycle 17-04-2009
No, I do not need the field to be a date/time field - I just thought that might be a way of making it work.I'd be grateful if you told me how to achieve your suggestion. I'm afraid I'm not an expert on scripting, and have practically no experience with it whatever. (an example might help)Much appreciated.

Views

185

Likes

0

Replies

0
Time Formatting - Adobe LiveCycle 16-04-2009
Can anyone tell me how to make a field with a formula in it turn the product of the calculation into time format (HH:MM)? For example, say you have two fields; Field 1, into which you input data, and Field 2 which gets the data from the Field 1 and changes it to time format. You put the value of 0.75 into Field 1, and Field 2 is supposed to change it to 1:15 (1hr, 15mins).I've tried making Field 2 a time field, but I can't get it to work. I've also tried to use that timefmt function, but either ...

Views

1.0K

Likes

0

Replies

6
Re: Scripting Help - Adobe LiveCycle 16-04-2009
Don't worry - I've done it!

Views

190

Likes

0

Replies

0
Re: Scripting Help - Adobe LiveCycle 16-04-2009
Thanks very much for that. I went with Niall's solution.Here's another couple though:=TRUNC([Cellname]/60)+([Cellname]-TRUNC([Cellname]/60))*60)/100)=([Cellname]-TRUNC[Cellname])*100+TRUNC[Cellname]*60

Views

163

Likes

0

Replies

0
Scripting Help - Adobe LiveCycle 15-04-2009
Could someone please convert the excel formula below into Formscript or Javascript language for me? Sorry, but I've run out of patience.=((([Cellname]-TRUNC([Cellname]))/60)*100)+TRUNC([Cellname])Thanks

Views

885

Likes

0

Replies

4