Jump to content


gfl

Member Since 21 Dec 2016
Offline Last Active May 06 2020 02:04 AM
-----

Posts I've Made

In Topic: Date/Time Formula calculation

13 March 2020 - 11:38 AM

Whatever works. 

 

I HAVE NOW FOUND A PARTIAL SOLUTION USING THE CUSTOM FORMULA FIELD TO CALCULATE TIME DIFFERENCES.

 

HOWEVER THE TIME DIFFERENCES THAT SHOW ON THE RECORD LISTS:

 

- DON'T SHOW ON GENERATED REPORTS

- DO SHOW ON THE SOME PRINTED REPORTS  BUT NOT ALL

- i HAVEN'T YET WORKED OUT HOW TO TOTAL TIMES FOR A TASK  TOTALING MULTIPLE RECORDS

 

THE CALCULATED TIME DOESN'T CHANGE WHEN THE START OR END TIMES ARE CHANGED, KEEPS THE RECORD CREATION TIME CALCULATION

 

 

I had mistakenly been using the {Attribute Label} formatting in the formula and not getting a result.

 

Now I'm using the 'Assigned To' feature to generate the field name and it works. The 'Assigned To' field name is different to the field name, prefixed by a 'c_'.

 

Now, subtracting a later date/time from an earlier date/time gives the number of seconds difference e.g. ={c_end}-(c_start}.