Z
Zaf
I am currently attempting to work out the flexi time earned and taken in a
week. The problem i am having is that if some one is taking flexi they would
have had to work more than 37:00 hours a week, so if they haven't the flexi
is a minus time. I need help with adding to times togeather in the format
[h]:mm only if two conditions are met which are that an "F" needs to placed
in a cell to confirm flexi being taken and one of the cells that need to be
added must be greater the 0:00. If flexi has been earned by working over
37:00 hours and not taken then it must role over to the following week, but
if flexi hours have not been earned (i.e less than 37:00 hours worked, so the
flexi is a minus time) than i need to clear the cell insted of rolling it
over to the next week.
These are the attempts that i have made with no luck;
=IF(AND(E10="F",H40>0),H36+H40,H40="")
=IF(E10="F",H36+H40,TEXT(H40,"-[h]:mm"))
=IF(E10:J10="F",TEXT(H36+H40,"[h]:mm"),TEXT(H40+I40,"[h]:mm"))
Any guidence would be greatly appreciated.
week. The problem i am having is that if some one is taking flexi they would
have had to work more than 37:00 hours a week, so if they haven't the flexi
is a minus time. I need help with adding to times togeather in the format
[h]:mm only if two conditions are met which are that an "F" needs to placed
in a cell to confirm flexi being taken and one of the cells that need to be
added must be greater the 0:00. If flexi has been earned by working over
37:00 hours and not taken then it must role over to the following week, but
if flexi hours have not been earned (i.e less than 37:00 hours worked, so the
flexi is a minus time) than i need to clear the cell insted of rolling it
over to the next week.
These are the attempts that i have made with no luck;
=IF(AND(E10="F",H40>0),H36+H40,H40="")
=IF(E10="F",H36+H40,TEXT(H40,"-[h]:mm"))
=IF(E10:J10="F",TEXT(H36+H40,"[h]:mm"),TEXT(H40+I40,"[h]:mm"))
Any guidence would be greatly appreciated.