Calculate days, hours, minutes and seconds between two times

[suprsnipes]

Hi,

I'm having trouble calculating the days, hours, minutes and seconds between two times, the times are as follows;

14/04/2011 10:26:27 PM
15/04/2011 10:30:00 PM

When doing a basic formula I get the following result
1/01/1900 12:03:33 AM

How can I get the correct result which?

Regards,
suprsnipes

 

[VoG]

You need to format the result cell as Custom d mm:hh:ss

 

[suprsnipes]

Thanks for your reply, I tried your suggestion but got the same result?

 

[VoG]

My result

Excel Workbook
	A
1	14/04/2011 22:26:27
2	15/04/2011 22:30:00
3	1 00:03:33
Sheet1

 

[suprsnipes]

Yes, ok, got it. Sorry - thanks.