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
|