Thread: Count the hours

Hi all,
I have this problem:

I want to count the total hours of running time for a machine, I have the Start/Stop time and date then what formular I should use?

	A	B	C
1	Start	2/25/10	23:15 PM
2	Stop	1/10/12	4:12 AM
3	Total hour:	????????????

Thanksssssssssss,

So long as B1 and B2 are both valid dates and C1 and C2 are both valid times then in B3 you can use the formula:

=((B2+C2)-(B1+C1))*24

Both of you gave me exactly what I need, I did not think that can be that simple TKS a bunch!!!!!!