S
sgl
Hi all!,
Need to compile a single formula that will compute payroll fractions for
crew on board ship who are paid on a calendar month basis. For eaxample
Start date End Date Ttl Month Ttl Pay Monthly
Ttl Pay
Days Days Pay
15-Feb-06 28-Feb-06 28.00 14.00 1,000.00 500.00
01-Mar-06 31-Mar-06 31.00 31.00 1,000.00 1,000.00
01-Apr-06 30-Apr-06 30.00 30.00 1,000.00 1,000.00
01-May-06 31-May-06 31.00 31.00 1,000.00 1,000.00
01-Jun-06 30-Jun-06 30.00 30.00 1,000.00 1,000.00
01-Jul-06 17-Jul-06 31.00 17.00 1,000.00 548.39
Ttl Pay days 153.00 5,048.39
15 Feb 06 is the date they join the ship and 17 Jul 06 is the date they
leave the ship. The user will enter a single pay period of say From 15 Feb 06
to 17 July 06 and the calendar month pay of say USD 1,000 and get the result
of 5,048.39 for the whole pay period.
Many thanks in advance/sgl
Need to compile a single formula that will compute payroll fractions for
crew on board ship who are paid on a calendar month basis. For eaxample
Start date End Date Ttl Month Ttl Pay Monthly
Ttl Pay
Days Days Pay
15-Feb-06 28-Feb-06 28.00 14.00 1,000.00 500.00
01-Mar-06 31-Mar-06 31.00 31.00 1,000.00 1,000.00
01-Apr-06 30-Apr-06 30.00 30.00 1,000.00 1,000.00
01-May-06 31-May-06 31.00 31.00 1,000.00 1,000.00
01-Jun-06 30-Jun-06 30.00 30.00 1,000.00 1,000.00
01-Jul-06 17-Jul-06 31.00 17.00 1,000.00 548.39
Ttl Pay days 153.00 5,048.39
15 Feb 06 is the date they join the ship and 17 Jul 06 is the date they
leave the ship. The user will enter a single pay period of say From 15 Feb 06
to 17 July 06 and the calendar month pay of say USD 1,000 and get the result
of 5,048.39 for the whole pay period.
Many thanks in advance/sgl