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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,491
Members
412,669
Latest member
nickyon1
Top