Results 1 to 16 of 16

How to round up parts of a week to whole weeks

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    06-23-2010
    Location
    North West
    MS-Off Ver
    office 2010
    Posts
    355

    How to round up parts of a week to whole weeks

    Excel 2010
    Happy New Year to all,
    I have updated an example page.
    I am trying to help a charity who hire out mobility scooters and wheelchairs but I'm having trouble doing it.
    They could be hired from as little as one day but could be out for 6 months or a year
    They charge a fixed fee of £5 for each week or part of a week, so if it is 7 days (one week) it is £5 and if it is 8 days it is £10
    I deduct the start date from the end date which gves the days and then try to convert that to weeks but it isn't working out too well. I would like 9 days for instance to = 1 week 2 days, but I can only get 1.29.
    The next problem is getting the weekly (or part weekly) fee of £5 to work. for nine days it should be £10. Is there a way of rounding up the amount of days to make an extra week.

    Thank you
    Attached Files Attached Files
    Last edited by nje; 01-07-2013 at 02:00 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1