Time function problem pt 2

F

Frank abel

Hi
if your total tiome (formated as [h]:mm) is in cell D20
and the contract houers a number in E20 use the following
formula
=MAX(D20-E20/24,0)
-----Original Message-----
Sorry, still not with it. Think I perhaps didn't pose the question correctly.

B6 - 08:30
C6 - 11:30
Total A.M Hours 3:00 =(C6<B6)+C6-B6 formatted as [h]:mm

Repeat for P.M hours and evening hours

=sum Formula then adds up all the total hours. I then
Click to expand...
type in contracted hours such as 40 and if their actual
hours come to 42:15 I need it to show me 2:15, it's the
2:15 I can't get. I have tried the suggestions, thank you
 
H

Hilary (UK)

Thank you. We're almost there! If they work more than the contracted hours it's working like a dream, but if they work less than contracted it's showing 0.00
 
P

Peo Sjoblom

=(D20*24)-E20

format as general, will give minus value if under 40
This is basically what you were told in your first post by Chip Pearson

--

Regards,

Peo Sjoblom


Hilary (UK) said:
Thank you. We're almost there! If they work more than the contracted
Click to expand...
hours it's working like a dream, but if they work less than contracted it's
showing 0.00
 
Top