Bespoke time management microsoft excel spreadsheet
- or -
Post a project like this3258
€10/hr(approx. $11/hr)
- Posted:
- Proposals: 5
- Remote
- #731650
- Awarded
Description
Experience Level: Entry
General information for the business: We provide website support and ongoing maintenance to our clients
Industry: Technology
Description of excel work: I need an excel spreadsheet that makes it as easy as possible for me to track time I use for clients. At present, I have a sheet that simply has a tab for each client but as my client list grows this gets harder to manage. Rather than add time when I do stuff, it needs to take time away from a pre-defined amount of support - and be able to do it in a set unit of time (15 mins, 10mins and so on) Here's more detail:
--
The prepaid support side of my business is growing and I need to be able to keep track of time. I’ve looked around for something to use but can’t find anything suitable.
Here’s what I need to keep track of…
Clients buy prepaid support in advance and it gets used as and when required in 15 minute chunks.
For each client I need to be able to add the number of hours they’ve purchased. Then when I do work for them, I need to be able to add a date, some detail on the work involved and the time element. The amount of time they have left then needs to be calculated.
So, we need to be able to add Clients.
I need to be able to add an amount of time that they’ve bought
We need to be able to edit the chunk of time (i.e. 15 mins, 30mins, 60mins) and preferably do this globally or on a client by client basis.
I need to be able to add a date, a description and how many chunks were used
The amount of time that is left then needs calculated automatically
Design and target audience: Internal Use only although it would be useful to be able to export timesheets to clients
Extra notes:
Industry: Technology
Description of excel work: I need an excel spreadsheet that makes it as easy as possible for me to track time I use for clients. At present, I have a sheet that simply has a tab for each client but as my client list grows this gets harder to manage. Rather than add time when I do stuff, it needs to take time away from a pre-defined amount of support - and be able to do it in a set unit of time (15 mins, 10mins and so on) Here's more detail:
--
The prepaid support side of my business is growing and I need to be able to keep track of time. I’ve looked around for something to use but can’t find anything suitable.
Here’s what I need to keep track of…
Clients buy prepaid support in advance and it gets used as and when required in 15 minute chunks.
For each client I need to be able to add the number of hours they’ve purchased. Then when I do work for them, I need to be able to add a date, some detail on the work involved and the time element. The amount of time they have left then needs to be calculated.
So, we need to be able to add Clients.
I need to be able to add an amount of time that they’ve bought
We need to be able to edit the chunk of time (i.e. 15 mins, 30mins, 60mins) and preferably do this globally or on a client by client basis.
I need to be able to add a date, a description and how many chunks were used
The amount of time that is left then needs calculated automatically
Design and target audience: Internal Use only although it would be useful to be able to export timesheets to clients
Extra notes:
Colin H.
100% (19)Projects Completed
27
Freelancers worked with
23
Projects awarded
47%
Last project
7 Dec 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies