I have found a workaround using workflows. Create 3 custom fields in Deals:
1) ‘today’s date’
2) ‘date entered current stage’
3) ‘time in current stage’
Add a series of workflows as follows:
1) updates ‘date entered current stage’ field when the stage is changed
2) daily schedule 3am that updates ‘today’s date’ field
3) daily schedule 4am that calculates difference between above fields and populates ‘time in current stage’
Seems to work OK. Have then extended that with additional if/then workflow to compare ‘time in current stage’ with a target for each stage and flag another custom field called ‘late in stage’ which can then be used as a focus for follow up
I trust that all makes sense