asked on April 10, 2017
Hi,
I have a scenario where there are two list fields, Start Time & End Time in a table
There is a field called Total.
The Start Time has entries at increment of 5 minutes like: 8:05, 8:10....17:05, 17.10
Same is for End Time: 8:05, 8:10....17:05, 17.10
Every row has these with a Total field at the end of the row.
What I want is if the user selects 8:05 in Start Time & 10:30 in End Time, the Total field should show the value as time worked, in this case 2 hours & 25 minutes.
I am not sure if this can be achieved by using formula or javascript?
Can someone please help?
Regards,
Sahil
0
0