You are viewing limited content. For full access, please sign in.

Question

Question

Cloud Forms: Time calculation

asked on January 23

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,

S

Screenshot 2023-01-23 at 11.19.39.png
0 0

Answer

SELECTED ANSWER
replied on January 25 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

Can someone please help?

0 0
replied on January 25

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
replied on January 25

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

Sonia,

 

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

TimeCalculations.PNG
0 0
replied on January 25

Perfect!!!

0 0
replied on January 25

Can you please share the formulas?

0 0
SELECTED ANSWER
replied on January 25 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.

Sign in to reply to this post.