View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default Time Calculation

"sjl" wrote in message
...
How do i format and calculate the time say for example 6/5/06 at 3:30 pm
to
6/6/06 4:35 pm?


=A2-A1, and format as [h]:mm, or whatever you prefer.
--
David Biddulph