Thread: [NEWBIE] date/time diff
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Jon is offline
external usenet poster
  
Posts: 183
Default [NEWBIE] date/time diff
I would like to create the following formulae:

A1: Start date/time e.g. Thursday 25/06/2009 08:00
B1: End date/time e.g. Thursday 25/06/2009 18:00
C1: Duration of break e.g. 01:00 (1 hour)
D1: B1 - A1 - C1 in hours

Any ideas?
Reply With QuoteReply With Quote