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

Question

Question

Forms time table calculation

Forms
Updated June 14, 2019
asked on June 13, 2019

Hello,

 

I am having some trouble getting a table with a time field calculation to work.

I entered the formula exactly as described in this post: 

https://answers.laserfiche.com/questions/127391/Time-Field-Table-Calculations-for-Hours-Worked-Timesheet-Process#127411  

but it will not calculate it. It won't give me an error message either.

Not sure if I'm missing something.

End Time:

Start Time:

Total Hours:

 

Any suggestions?

0 0

Answer

SELECTED ANSWER
replied on June 14, 2019 • Show version history

Hi Rex,

 

From your setup screenshots, it looks like you've added Date fields to the form but on the table preview you only show the times. If you use date fields then you will need to fill in both date and time. If you use a Time field then the calculation will work with just time.

 

Just to test it I did up a quick form to try it out. I've attached an export of it if you wanna have a look. You'll need to change the extension from .txt to .xml and then you can import it into forms.

Time Calculation Test.txt (19.07 KB)
Download
0 0
replied on June 14, 2019

That worked! I just needed to change the Date fields to Time

Thanks!

0 0
replied on June 14, 2019

Now I'm trying to get the sum of the Total Hours column.

I've tried a few different formulas and nothing seems to work. The Total Hours Driven is a number field.

Any suggestions?

0 0

Replies

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

Sign in to reply to this post.

Details
Attachments
Related Posts
Loading ...