need help on calculating straight time

terla

New Member
Joined
Dec 21, 2005
Messages
0
Hi ...can someone help me with the formula that calculate straight time w/o showing the total number of regular time.
for instance, reg time = 37.5 anything after that will be straight..so if someone work 3 hrs more than the regular time...i just wanted to show the number 3 instead the total number of 40.5.
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,118,287
Messages
5,571,318
Members
412,382
Latest member
Langtn02
Top