Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |