calculate cells with format hh:mm
It works because XL stores times as fractional days. 18:00 is 18/24ths
of a day, or 0.75.
No idea what "I clicked YES" means, but thanks, I guess...
In article ,
Rockbear wrote:
Thank you it worked, the =MAX(0, B2-0.75) worked but could not make the other
one work.
Have two more questions :
1.
Why the -0,75?? it works but could not understand why it works
2.
IF the same formula (=MAX(0, B2-0.75) ) should be used between 18:00 and
21:00, and list only the hours between 18:00 and 21:00, and a new one from
21:00
between 18:00 and 21:00 the get 40% additional sallary
and after 21:00 they get 100% more, would have bee SO nice to be able to
make this calculation automatic
Thanks for the efford, and I clicked YES on your first reply, and help :)
|