Excel calculation of duration in hours and minutes

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

 

[SteveW]

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

Steve

 

[Sandy Mann]

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

 

[Esbee]

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?

 

[David Biddulph]

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.