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

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.
--
David Biddulph

"Esbee" wrote in message
oups.com...
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?