Calculate the number of hours between two dates and times

's Computer Specifications

I need to calculate the number of hours and minutes between two dates
and the time.
For e.g. 23.10.05 10:00 and 25.10.05 10:15. Does anyone knw how to do
this.
Thanks a lot

Princy

's Computer Specifications

=A2-A1 (If A2 is the largest)
Format Custom as [h]:mm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

<(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
|I need to calculate the number of hours and minutes between two dates
| and the time.
| For e.g. 23.10.05 10:00 and 25.10.05 10:15. Does anyone knw how to do
| this.
| Thanks a lot
|
| Princy
|

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate the number of business hours between two dates.	Mufasa	Microsoft C# .NET	4	25th Aug 2010 05:00 PM
Calculate hours between to separate dates and times	Dave08	Microsoft Excel New Users	7	13th Oct 2008 10:36 AM
How do I calculate dates and times, w/answer of days & hours	=?Utf-8?B?RGViYnlfSm8=?=	Microsoft Excel Worksheet Functions	4	27th Apr 2007 04:05 AM
Calculate number of hours between dates and times excluding Weekends	princy_varghese@hotmail.com	Microsoft Excel Misc	1	21st Oct 2006 02:16 AM
How can I calculate hours between times with dates that are great.	=?Utf-8?B?UmFnZ2VkeUFubg==?=	Microsoft Excel Crashes	2	14th Oct 2004 03:56 PM