View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GARYWC GARYWC is offline
external usenet poster
 
Posts: 80
Default Compute time differences

What formula will compute the number of hours and minutes between the Start Time and the End time in each row?

(Each cell is formatted as number, custom, type: h:mm AM/PM)

Start time End time
12:45 PM 3:14 PM
10:20 AM 12:10 PM
10:20 AM 12:30 PM
9:30 AM 11:30 AM
10:00 AM 12:24 PM
11:20 AM 1:40 PM
11:27 AM 1:42 PM
1:35 PM 3:51 PM
10:30 AM 12:38 PM
11:55 AM 2:05 PM
10:05 AM 12:00 PM
12:00 PM 2:10 PM
10:00 AM 12:50 PM
11:55 AM 1:40 PM
12:45 PM 2:58 PM
12:45 PM 3:13 PM