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

Question

Question

time calculation

asked on November 18, 2019

Hi Everyone,

 

I have a problem with time calculations in Laserfiche Forms Professional Version 10.4.0.1256

 

I have a business process with a number of different tasks and forms.

 

I use a datetime to record a starting time and again a datetime to record an ending time.

This then gives me a time worked based on a fx calculation SUB(Timeend,Timestart)

 

The problem is that i have two "worked hours" calculated in this manner. This means that i cannot use the time field. And the calculation returns the time perfectly BUT  it returns the date with a funny year. how can i fix this?

 

I have:

assessment time which is based on a starting and ending time +
Fixing time which is based on a starting and ending time

 

Which i use for two calculations:

Time work on device which is the sum of the results and
SLA which is the difference between the fix end date and assessment start date. 

 

I hope this makes sense and will appreciate some help very much!

 

 

 

 

 

0 0

Replies

replied on November 18, 2019

SUB and SUM are used for numbers. For calculating the difference between 2 dates, you want to use DateDif.

0 0
replied on November 18, 2019

Thank you Miruna, the problem is that the datedif function also results in an error, i think this is because i am not using the date only but the date and time?

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

Sign in to reply to this post.