Hi Guys,I wanted to know, Is it possible to create a Javascript Function based calculation for a timesheet that also includes amount of people working during that time period.Example.StartFinishNumber of workersTotal HoursStart1.0Finish1.0Workers1.0Totalhours1.0Start1.1Finish1.1Workers1.1Totalhours1.1Start1.2Finish1.1Workers1.2Totalhours1.2My function would be something like CalcHours() ….. which would yield something like would calculate like this (Finish1.0 - Start1.0) * Workers1.0your helps would be greatly appreciated.

Participating Frequently

Question

Function for timesheet calculation

Forum|Forum|6 years ago
March 25, 2019
1 reply
953 views

Hi Guys,

I wanted to know, Is it possible to create a Javascript Function based calculation for a timesheet that also includes amount of people working during that time period.

Example.

Start	Finish	Number of workers	Total Hours
Start1.0	Finish1.0	Workers1.0	Totalhours1.0
Start1.1	Finish1.1	Workers1.1	Totalhours1.1
Start1.2	Finish1.1	Workers1.2	Totalhours1.2

My function would be something like CalcHours() ….. which would yield something like would calculate like this (Finish1.0 - Start1.0) * Workers1.0

your helps would be greatly appreciated.

This topic has been closed for replies.

rayek.elfin

Legend

Is there a particular reason to use a Javascript function for this simple calculation? Otherwise just use a Simplified Notation calculation field for your total hours field with this formula:

((finishTime - startTime)*numberOfWorkers)