Hi Guys!
I am creating a Timesheet process and trying to automatically work out the time worked from start time & finish time manually input from the user.
I have added the following formula:
=(INDEX(Timesheet.FinishTime_1,ROW())-INDEX(Timesheet.StartTime_1,ROW()))
which I realised brings back the time difference in seconds, so I called this field 'Total Seconds'. So I created another field called 'Convert to Hours' which I was hoping to add this formula to:
=(INDEX(Timesheet.Total_Seconds,ROW())/3600) to get the time converted to hours (works in a calculator) but unfortunately I end up with the figure below:
The Total Hours field above we have got working with JavaScript but we are still working on having this work for each row. So if anyone has done this before and can tell me how to achieve this by the formulas or JavaScript then it would be much appreciated!
Thanks
Tina