Difference of date & time in minutes

[ramsdesk]

I have two columns with date+time format. I need the difference of this
in minutes.

For eg:

11/09/2004 10:00:00 AM <minus> 11/09/2004 05:00:00 PM = 420 minutes

This should work even if dates are different.

Pls help.

TIA.

 

[Biff]

Hi!

Did you mean:

11/09/2004 05:00:00 PM <minus> 11/09/2004 10:00:00 AM

=(A1-B1)*1440

Format as GENERAL.

If you did mean:

11/09/2004 10:00:00 AM <minus> 11/09/2004 05:00:00 PM

=ABS(B1-A1)*1440

Biff

 

[Arvi Laanemets]

Hi

A1=11/09/2004 10:00:00 AM
B1=11/09/2004 05:00:00 PM
Into some cell, p.e. C1, enter the formula
=B1-A1
and format the cell with formula as Custom "[m]"

NB! Don't forget the result is in time format - i.e. 420 minutes is in excel
a number ~0.291666667. When you have to use somewhere as number of minutes
(420), multiply it with 24*60