View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default Excel calculation of duration in hours and minutes

Format as [h]:mm rather than hh:mm

Steve

On Fri, 09 Feb 2007 15:11:49 -0000, wrote:

The standard functions in excel allow to calculate duration in hours
and minutes, using the format hh:mm for the result. However; hh:mm is
normally used only for clocktime: any duration of more than 23:59 will
start again from 00:00, whilst the result could be any figure (24:00;
168:00, ...). Does Excel provide a solution?