View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grushenka Grushenka is offline
external usenet poster
 
Posts: 2
Default How can I automatically split values over specified time periods?

Hi, I monitor the energy usage for my organisation and report quarterly. As
you will be aware, utility bills do not always come in nice and neat
quarterly or monthly invoicing periods and I would really benefit from a way
of automatically splitting amounts entered into quarters. e.g

I enter 25 Dec 07 to 04 Feb 08 = 1000 kwh

Rather than manually dividing myself, can I allocate 5 days usage to the Oct
to Dec quarter and the rest to the Jan to Mar quarter?

Any help would be greatly appreciated :)