It sounds like you have a single select field for {Status}. Try adding a few new fields and an automation.
- A Last Modified Time field that watches the {Status} field
- An editable date/time field for storing the {time assigned}
- A editable date/time field for storing the {time done}
- A formula field that calculates the difference between the {time done} and {time assigned}
- An automation that watches when the {Status} is updated. If the {Status} is assigned, copy the last modified time to the {time assigned}. If the status is done, copy the last modified time to {time done}
Thanks @kuovonne ! I have managed to do the first parts of your suggestions.
Could you walk me through the automation in detail a bit more? If possible sharing a screen shoot or two. I have not worked with automations before.
Thanks and much appreciated!
Hi again @kuovonne ,
I cant get passed this step in the autimation:

In your Update record action, it looks like you are putting the last modified time field value where the internal record ID of the triggering record goes. The {LTM - Status} value should go as the value for the {Time assigned} field.
This support article has more info on how to configure an update record action.
thanks @kuovonne for your help. I not got it figure out.