# Question

### Cloud Forms: Time calculation

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.

Regards,

S 0 0

replied on January 25

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

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

Perfect!!!

0 0
replied on January 25

Can you please share the formulas?

0 0
replied on January 25

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.