On Wed, 2 Jun 2010 03:58:01 -0700, Steve M
wrote:

Hi
Both of the solutions above work within a 24 hour period, but some jobs can
go over by a few days so I need it to show this in either hours or days and
hours.
many thanks do far

You will need to enter start and end times including the dates.
Then format the result as [h]:mm to allow to show hours more than 24.