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

Question

Question

Laserfiche Forms to Subtract 2020-02-05 10:00:00 with 2020-02-06 12:00:00

Forms How To Version 10
Updated February 6, 2020
asked on February 5, 2020

Hi

I need JS or Excel function to achieve the following: (Column 1 - Column 2 = x in Column 3)

I'd like the amount of hours that the above calculation does. So if it took me 1 day and 2 hours I'd like 26 to print out in column 3.

I cannot seem to win this one. Been at it for an entire morning.

Thanks in advance!

0 0

Answer

SELECTED ANSWER
replied on February 6, 2020

=(INDEX(Table.Column_1,ROW())-INDEX(Table.Column_2,ROW()))*24

0 0

Replies

replied on February 5, 2020

So just got this to work "=DATEDIF(INDEX(Table.Column_1,ROW()),INDEX(Table.Column_2,ROW()),"D")"

Doing this:

Any ideas how to do hours?

Thanks

0 0
SELECTED ANSWER
replied on February 6, 2020

=(INDEX(Table.Column_1,ROW())-INDEX(Table.Column_2,ROW()))*24

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...