Calculate the hours between 2 times

[Gunn]

Hi

First Post .... Be gentle

I'm trying to calculate the hours works between 2 times i.e wed start 09.00 finish 16.25 and returning 7 hours 25mins

Cheers

 

[wwbwb]

Just subtract the two

Book1.xls
	F	G	H	I
1	9:00	16:25	7:25
Sheet1

 

[fairwinds]

Welcome to the board!

Try:

=TEXT(B1-A1,"[h]")&" hours "&TEXT(B1-A1,"m")&" mins"

 

[Gunn]

Cheers working a treat .......