G Gunn New Member Joined Nov 21, 2005 Messages 2 Nov 21, 2005 #1 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
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 Well-known Member Joined Oct 20, 2003 Messages 513 Nov 21, 2005 #2 Just subtract the twoBook1.xlsFGHI19:0016:257:25Sheet1
fairwinds MrExcel MVP Joined May 15, 2003 Messages 8,638 Nov 21, 2005 #3 Welcome to the board! Try: =TEXT(B1-A1,"[h]")&" hours "&TEXT(B1-A1,"m")&" mins"