Calculate difference between times and dates

[Stuck2]

Hi,

I have a two lists of "ddmmyy hh:mm:ss" in two separate columns. I need to calculate the time difference between the two values so that it returns the value in hh:mm:ss.

So for example -
A1 - 07/05/2011 07:29:52
B1 - 08/05/2011 13:41:12
I need to return the time difference in hh:mm:ss between the dates/times in A1 and B1. My formula of =B1-A1 won't work when the dates are different in the two cells.

I have a lot of data that I need to work out the time difference for so I really need a formula that I can apply to all of the rows of data.

Thank you very much in anticipation!

 

[VoG]

You can use =B1-A1 and format the result cell as Custom

[h]:mm

 

[Trevor G]

Hi,

I have a two lists of "ddmmyy hh:mm:ss" in two separate columns. I need to calculate the time difference between the two values so that it returns the value in hh:mm:ss.

So for example -
A1 - 07/05/2011 07:29:52
B1 - 08/05/2011 13:41:12
I need to return the time difference in hh:mm:ss between the dates/times in A1 and B1. My formula of =B1-A1 won't work when the dates are different in the two cells.

I have a lot of data that I need to work out the time difference for so I really need a formula that I can apply to all of the rows of data.

Thank you very much in anticipation!

Welcome to the forum try these out, the last one is simple one cell away from the other then used custom format

Excel Workbook
	A	B	C	D	E
1	Start	End	Hours	Minutes	Custom format used [h]:mm
2	07/05/2011 07:29	08/05/2011 13:41	30	1811	30:11
Sheet2

 

[Stuck2]

That's brilliant thank you so much - the custom format using [h]:mm:ss did the trick.

Thanks again