Time Problem

[MrData]

I'm supplied with three columns of data as shown in the table below. However the third column is supposed to show the time difference in minutes but there is a problem. As you can see the time difference is wrong. I've tried various formulas but cannot get it to work. Can anyone help?

Start End Incorrect Correct
01:09 01:10 1 1
01:09 01:00 -1449 -51
01:13 00:35 -1478 -38
01:13 00:50 -23 -23

 

[Asala42]

I'm not sure how you get -51 on the second row from 1:09 vs 1:00.

Assuming that was typo'd, try this formula:

=IF(B2< A2,-1,1)*ABS(A2-B2)*1440

edit - formula getting truncated
Ignore the space in "B2< A2"

 

[TheCman81]

Is your data correct? For instance below you have:

01:09 01:10
01:09 01:00
01:13 00:35
01:13 00:50

You have one start time as 01:09 and an end time of 01:00?

It should just be a basic end minus start!

 

[texasalynn]

I'm not getting the same values for all

Excel 2003
	A	B	C	D	E
1	Start	End	Incorrect	Correct	formula
2	1:09	1:10	1	1	0:01
3	1:09	1:00	-1449	-51	-0:09
4	1:13	0:35	-1478	-38	-0:38
5	1:13	0:50	-23	-23	-0:23
Sheet3

Cell Formulas
Range	Formula
E2	=+B2-A2