S
sallyt
Help! Is there a way of doing this please: I want to
multiply number of hours a person has worked (eg 35)
x .385 (which is the number we have calculated that works
out holiday entitlement on a weekly accrual basis) then
divide that by 4, eg =(35*.385)/4 I then want to take
that result and display not in decimal figures but in
total hours and minutes. Have tried =TEXT divided by
24, as per help, but this doesn't seem to do what I want.
Any clues please? Thanks. Sall
multiply number of hours a person has worked (eg 35)
x .385 (which is the number we have calculated that works
out holiday entitlement on a weekly accrual basis) then
divide that by 4, eg =(35*.385)/4 I then want to take
that result and display not in decimal figures but in
total hours and minutes. Have tried =TEXT divided by
24, as per help, but this doesn't seem to do what I want.
Any clues please? Thanks. Sall