Difference of date & time in minutes
 

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.


--
ramsdesk
------------------------------------------------------------------------
ramsdesk's Profile: http://www.excelforum.com/member.php...o&userid=15705
View this thread: http://www.excelforum.com/showthread...hreadid=276871

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

-----Original Message-----

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.


--
ramsdesk
----------------------------------------------------------
--------------
ramsdesk's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=15705
View this thread:
http://www.excelforum.com/showthread...hreadid=276871

.

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


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"ramsdesk" wrote in message
...

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.


--
ramsdesk
------------------------------------------------------------------------
ramsdesk's Profile:
http://www.excelforum.com/member.php...o&userid=15705
View this thread: http://www.excelforum.com/showthread...hreadid=276871