View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default Date and Time Calculations

=A1-A2 and format as [h]:mm
--
David Biddulph

"wayne" wrote in message
...
How can I calculate the difference between a date and time format and
another
date and time format? I would like the return value be in hours.

Ex: 10/27/2006 10:00 - 10/26/2006 12:00 = 22 hours