Question

Cloud Forms: Time calculation

Laserfiche Cloud Forms

Updated January 25, 2023

asked on January 23, 2023

Hello,

I am trying to get the time calculation of two fields, I am using the following formula:

=ROUND(SUB(INDEX(Time.End,ROW()),INDEX(Time.Start,ROW()))*24,86200)

However it's incrementing the time..... hour is working fine, but minutes is not...

What I want is that it should show correct values.

Can someone please help?

Regards,

Screenshot 2023-01-23 at 11.19.39.png (83.53 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on January 25, 2023 • Show version history

For the Total (Number Field) I used the following:

=ROUND(SUB(INDEX(Time.End,ROW()),INDEX(Time.Start,ROW()))*24,2)

For Total Time (Time Picker Field) I used this:

=SUB(INDEX(Time.End,ROW()),INDEX(Time.Start,ROW()))

0 0

Replies

replied on January 24, 2023

Can someone please help?

0 0

replied on January 25, 2023

Hello Sonia,

After playing with this a bit, what is happening is the minutes are being displayed as percentages of hours. so 11:18 - 11:19 rounds to 2% of an hour or 0.02 hours.

How would you like the display? HH:MM? So that it displays as 00:01?

Regards,

Travis

0 0

View 2 previous replies

replied on January 25, 2023

Hi Travis,
You are right, I made the subtotal also Time & it works!

Actually if you could suggest how to display there same in number, would be awesome!

Thanks

0 0

replied on January 25, 2023

Sonia,

Is this what you mean by displaying the same in number?

TimeCalculations.PNG (33.43 KB)

| Download

0 0

replied on January 25, 2023

Perfect!!!

0 0

replied on January 25, 2023

Can you please share the formulas?

0 0

SELECTED ANSWER

replied on January 25, 2023 • Show version history

For the Total (Number Field) I used the following:

=ROUND(SUB(INDEX(Time.End,ROW()),INDEX(Time.Start,ROW()))*24,2)

For Total Time (Time Picker Field) I used this:

=SUB(INDEX(Time.End,ROW()),INDEX(Time.Start,ROW()))

0 0

You are not allowed to follow up in this post.

Question

Question

Cloud Forms: Time calculation

Answer

Replies

Sign in to reply to this post.