Excel invoice using labour charges based on date & time

  • Status Completed
  • Budget £30 - £250 GBP
  • Total Bids 30

Project Description

A simple little project for someone with excel knowledge, I have an excel spreadsheet template,

sheet 1 is a printable invoice,

sheet 2 contains data for UK VAT rate, product pricelist and labour charges.

Date & Time Pickers

On the invoice there needs to be a date and time selector for start and end time. This needs to the compare the dates and times against 3 different pricing bands Band A between 8:00 and 17:00 (mon - fri) Band B between 17:00 and 8:00 (mon - fri) and Band C Weekends & UK Bank holidays. Bank holidays may be a pain so it may need a selector to switch to band a/b/c rates aswell as the automatic one. Each price band needs a callout charge 1 off and then an hourly charge for time during that band, if it crosses bands for example late friday tosaterday morning it needs to charge two sets of hourly rates some at Band A some at Band C, hope that makes sense

Item selection

pull down boxes that select an item from the data sheet and fills in the prices in the invoice

Get free quotes for a project like this
Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online