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?

[TABLE="width: 300"]
<tbody>[TR]
[TD="class: xl65, width: 100"]6:11 PM[/TD]
[TD="class: xl65, width: 100"]6:55 AM[/TD]
[TD="class: xl63, width: 100"]-676
[/TD]
[/TR]
</tbody>[/TABLE]

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]

[TABLE="width: 436"]
<colgroup><col><col span="2"><col></colgroup><tbody>[TR]
[TD]1)[/TD]
[TD]10:55 PM[/TD]
[TD]12:55 AM[/TD]
[TD]120[/TD]
[/TR]
[TR]
[TD]2)[/TD]
[TD]10:55 PM[/TD]
[TD]12:55 AM[/TD]
[TD]1,320[/TD]
[/TR]
</tbody>[/TABLE]

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.