Level 1

0% to

Level 2

Tip /

to gain points, level up, and earn exciting badges like the new
Mission!

View all

Alijay
Offline

2

Accepted Solutions

Accepted Solutions
0

Likes

Likes
0

Posts

Posts
3

Discussions

Discussions
0

Questions

Questions
3

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Alijay
Level 1

Likes

0 likes

Total Posts

3 posts

0 solutions
View profile
Alijay
Hello,Hoping that someone can help me with FormCalc code. I am a novice at LiveCycle and by no means a programmer. I am currently working on a form where several sets of START and END times (24hr clock) are entered - sometimes more than 10 sets.The form is then supposed to calculate the difference between each set of times then give a total time.E.g.START1: 14:00END1: 14:30TOTAL1: 0:30 START2: 14:45END2: 15:35TOTAL2: 0:50START3: 15:40END3: 15:55TOTAL3: 0:35 TOTAL TIME: 01:55START14:0014:4515:40E...

Views

1.2K

Likes

0

Replies

1
Re: FormCalc Newbie, Time Difference Equation
Alijay
Level 1

Likes

0 likes

Total Posts

3 posts

0 solutions
View profile
Alijay
Hi,Im not sure if you still need assistance, but the following worked for me. I found it in an earlier thred and tweaked it a bit. Im also not very familiar with code but I hope it works for you. var TimeCountvar OneMinute = 1/60var StartTime=Time2Num(Row3.Start1.formattedValue,"HH:MM")var EndTime=Time2Num(Row4.End1.formattedValue,"HH:MM")if (StartTime ne null and EndTime ne null) then //if start time is lower than end time. if (Time2Num(Row3.Start1.formattedValue, "HH:MM") < Time2Num(Row4.End1....

Views

162

Likes

0

Replies

0
Alijay
Level 1

Likes

0 likes

Total Posts

3 posts

0 solutions
View profile
Alijay