How to calculate time difference in hrs

's Computer Specifications

Dear All,

which functions shd i use to calculate the time difference between or with
ref. to 2 dates

i.e: 23/Nov 2300hrs -> 25/Nov 0100hrs = 26hrs (result I want)

's Computer Specifications

A1 = 23/Nov 2300hrs
B1 = 25/Nov 0100hrs
C1 = Formula =(A1-B1)*24

"Will" wrote:

> Dear All,
>
> which functions shd i use to calculate the time difference between or with
> ref. to 2 dates
>
> i.e: 23/Nov 2300hrs -> 25/Nov 0100hrs = 26hrs (result I want)

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate time difference	da	Microsoft Excel Misc	1	15th Mar 2010 06:45 PM
calculate difference of time	=?Utf-8?B?WGF2aWVy?=	Microsoft Excel Programming	2	22nd Mar 2006 02:19 PM
Calculate Time Difference	=?Utf-8?B?Um9zZW1hcnk=?=	Microsoft Access Form Coding	5	28th Feb 2005 12:47 AM
How to calculate a Time Difference	=?Utf-8?B?ZHdhbHNoNzc=?=	Microsoft Excel Misc	2	10th Nov 2004 09:14 AM
How to calculate time difference?	barton	Microsoft Access	0	12th Jul 2004 06:31 AM