View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default CALCULATE DIFFERENCE BETWEEN 2 TIMES - RESULT IN MINUTES

In Excel 2007 :

Office buttton
Excel options
Proofing
Autocorrect options
Autoformat as you type tab

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"CB" wrote in message ...
I'm looking for a way to calculate the difference in time in minutes for the
following format. Taking the date into consideration. Can you help? I
apologize if this is a 2nd posting but I can 't find the first so I don't
think it took.

Thanks

A B
2 start time end time
3 2007-05-19 13:48:49:295 2007-05-20 01:42:31:593