Formula calculate minutes.

[asyamonique]

=(F3-E3)*1440

Hello,
Above formula gives me the time calulation as minutes of between two cells.
Can you please give me solution to fix that problem given below?

6:11 PM

6:55 AM

-676

<tbody>
</tbody>

should not show the minutes as negative!

Many Thanks

 

[Rick Rothstein]

See if this works for you...

=MOD(1440*(F3-E3),1440)

 

[kennek]

6:11 is a lower value than 6:55. Written in military time it would be 6:55 - 18:11.

 

[kennek]

I wrote that backwards. 6:55AM is a smaller value than 6:11PM. In military time that would be 6:55 - 18:11

 

[Rick Rothstein]

6:11 is a lower value than 6:55. Written in military time it would be 6:55 - 18:11.

I am not sure what you are trying to say here as the formula you asked about already assumed that.

Did you try the formula I posted in Message #2 yet?

 

[kennek]

I was answering the original posters question as to why the answer is negative. He stated that the answer should not be negative. He was subtracting a larger value (6:11PM/18:11) from a smaller value (6:55AM)

 

[Rick Rothstein]

I was answering the original posters question as to why the answer is negative. He stated that the answer should not be negative. He was subtracting a larger value (6:11PM/18:11) from a smaller value (6:55AM)

I am sorry... I mistook you for being the OP (your double post fooled me, but my fault for not looking back).

 

[Marcelo Branco]

If both times are always the same day, maybe ...

=(MAX(E3,F3)-MIN(E3,F3))*1440

M.

 

[asyamonique]

1)	10:55 PM	12:55 AM	120
2)	10:55 PM	12:55 AM	1,320

<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>

1)

=MOD(1440*(F14-E14),1440)

2)

=(MAX(E15,F15)-MIN(E15,F15))*1440

Hello All,
Sorry for late post.
Rick's formula helped me so far.
Other formula gives wrong result.
Thanks.