View Single Post
  #8  
Old June 2nd, 2010, 12:15 PM posted to microsoft.public.excel.misc
Ron Rosenfeld[_2_]
external usenet poster
 
Posts: 9
Default Calculate the amount of time over a permitted amount (12 hours

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.