Calculate the hours between 2 times

Gunn

New Member
Joined
Nov 21, 2005
Messages
2
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
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Welcome to the board!

Try:

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

Watch MrExcel Video

Forum statistics

Threads
1,118,820
Messages
5,574,511
Members
412,599
Latest member
Schu94
Top