Compute minutes between hh:mm

[gary]

What formula will compute the number of minutes between the time in each cell?

6:56
7:03
7:11
7:16
11:31
11:38
11:52
12:05
12:18
12:32
15:06
15:17
15:29

 

[isabelle]

hi,

i suppose times are in the cells A1: A13
put cell B2 in the format [h]:mm
in cell B2 enter the formula = A2-A1
and then fill down

isabelle

Le 2014-04-23 19:14, gary a écrit :

 

[Bruce Sinclair]

What formula will compute the number of minutes between the time in each cell?

6:56
7:03
7:11
7:16
11:31
11:38
11:52
12:05
12:18
12:32
15:06
15:17
15:29

Suggest you simply use '-' and format the result cells to show minutes.