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

.