View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Gnugs Gnugs is offline
external usenet poster
 
Posts: 1
Default Elapsed time when separate cells contain time and separate date

Have 2 pairs of cells representing two events -- a date and time for each
event stored as text with the date cell in form mm/dd/yyyy and the time cell
in form hh:mm xM. Need to find the elapsed time between the two events in
hours and minutes placed in separate cells.