View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ferde ferde is offline
external usenet poster
 
Posts: 87
Default minutes calculation formula

A B C D
E
DateArriv TimeArriv DateDepart TimeDepart Total Minutes
8/8/2007 14:30 8/8/2007 14:45
8/9/2007 15:00 8/9/2007 21:00
8/10/2007 13:00 8/11/2007 6:00


Can anyone tell me the formula for calculating the total minutes for column
E. When the dates changes past midnite....its tricky . Also I cant find a
format for just minutes for column E

Thank you
Deb