Excel calculation of duration in hours and minutes

  • Thread starter Thread starter sblockhuys
  • Start date Start date
S

sblockhuys

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?
 
Yes it does. Try a custom format of [hh]:mm

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Great, it works! Thanks for the turbo response. May I add a
complication? The difference between scheduled time and actual time
(Time A - Time B) can also be negative: however, excel does not allow
a negative time-value... Or does it?
 
Tools/ Options/ Calculation/ 1904 date system
But if you do that, be careful if you are trying to transfer dates to and
fro with spreadsheets set up with the conventional 1900 system.
 
Back
Top