Help for 2014-2015 spreadsheet please!!
Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2009
    Posts
    156
    Registered Childminder since
    SEPT 09
    Post Thanks / Like

    Default Help for 2014-2015 spreadsheet please!!

    I downloaded the Account 2014-2015 spreadsheet from off of here. I have been filling it in and I have to say it greats. Thank you to the person who created it.
    I am having a problem with filling in the hours worked sections tho. When I put 07.30 as a start time it changes it to 7.12. the if I put 18.00 for finish time it changes it to 00.00 and says I' ve worked something like 230hrs for that day..
    Im no good with spreadsheets at the best of times.....so can someone please give me some advice. Thanks

  2. #2
    Join Date
    Dec 2008
    Posts
    1,239
    Registered Childminder since
    sept 05
    Latest Inspection Grade
    Good
    Post Thanks / Like

    Default

    Hi, im sorry im no help but wondered where is the spreadsheet please?

    Thanks

  3. #3
    Join Date
    Sep 2014
    Posts
    20
    Registered Childminder since
    feb 02
    Post Thanks / Like

    Default not sure if this will help u Kerry30,but u could try!

    I am hopeless when it comes to I.t, but do have a monthly spread sheet that somebody helped set up for me. I have to put on the hours in decimal format. E.g, for it to tally all my hours and calculate my total fees. I just put in the start time and finish time but if it was 7.30 am to 5.15 pm I have to fill it in as 07.50 to 17.25 or 3.30 to 6.45 would be put in as 15.50 to 18.75. I clock in and out to the nearest quarter of the hour so it stays simple and also works well when parents turn up late. If mum is supposed to pick up at 6pm but doesn't arrive until 6.10 then I put in 18.25. Never had a complaint from parent and I don't feel like I'm being taken for granted as I'm paid for every minute. (I do go through this at induction meeting).

  4. #4
    Join Date
    Feb 2010
    Location
    at the mad hatters' tea party
    Posts
    1,620
    Registered Childminder since
    Sept 90
    Latest Inspection Grade
    Good
    Post Thanks / Like

    Default

    You have to use the Colon sign : not a full stop and then it works and always 2 figures before and after it
    Last edited by cathtee; 01-01-2016 at 04:30 PM.
    Cath

  5. #5
    Join Date
    Feb 2008
    Location
    Teetering....
    Posts
    4,079
    Registered Childminder since
    Apr 01
    Post Thanks / Like
    Blog Entries
    1

    Default

    Quote Originally Posted by Jelly Baby View Post
    Hi, im sorry im no help but wondered where is the spreadsheet please?

    Thanks
    It's here kindly shared by Happytoddlers This is the thread the other link is direct to the spreadsheet

    http://www.childmindinghelp.co.uk/fo...k-updated.html

    Childminding Accounts Worksheet Download - Home

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Quick Links and Advertisements

Important Information Links
Some Useful Quick Links
Advertisements

 

You can also find us on:
Help for 2014-2015 spreadsheet please!! Help for 2014-2015 spreadsheet please!! Help for 2014-2015 spreadsheet please!!

We use cookies to make this site as useful as possible. They are small text files placed in your browser to track usage of our site but they don’t tell us who you are.
By continuing to use this site you are consenting to cookies being placed on your computer. Find out more here: Cookies in Use

Childminding Help and the Childminding Forum are part of Childcare.co.uk