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?
|