I am looking to solve 2 problems with calculating times.

 

1) An auto calculation of times with an input of Start hours and Finish hours for individual jobs on projects.

2) A running total of these times like you would do with =SUM() in a spreadsheet to get a final total of hours worked.

 

For time input, I am using the time fields for Start_time and End_time, and a single line for Total_hours.

 

The calculation is required for invoicing, so this is how it would look as an example:

Start Time (eg 8:00 am) End Time (eg 10:15 am) = 2.25 hours

NOT 2 hours and 15 minutes. (However, if this cannot be done that is fine).

 

Secondly, I need a running total for all hours calculated for each individual job in the jobs report. As an example, I have 1 project x 4 days of jobs at 6hrs each = 24 Total hours for this project.

This type of calculation is straightforward in a spreadsheet which I am using, however, it appears rather troublesome to do this in Creator as it is hard to find examples.

Lastly which would be great is that the total hours calculated for all jobs be reflected in the projects report somehow. I have not worked out if this is possible yet.

 

I believe with the new workflow created I am to > record the event when created or edited > select user input of a field, but from here is where I get stuck with what fields to put this in and writing the actual script.

 

Would anyone be able to help with this?

 

I am able to provide screenshots of current workflows if someone is willing to help.