Results 1 to 3 of 3

Counting days between set dates

Threaded View

  1. #1
    Registered User
    Join Date
    11-17-2011
    Location
    Shropshire
    MS-Off Ver
    Excel version 2102
    Posts
    85

    Counting days between set dates

    I am doing atime sheet! - where I work there are lots of different shift patterns, for example a four week rolling rota.

    Currently I have one week where people select days of the week they work I wondered if I could perhaps instead of putting what days are worked in one week, have 4 weeks and then how many hours are worked that day in a column, then for it to count how many days on that work pattern are worked and then a total of hours between two given dates.

    Hope that makes sense and I’ve also attached an example of what formula I am currently using and an example of a four week work pattern.

    Really hope you can help - I'm not always great at describing what I am after, so any questions please ask.

    Thanks
    K
    Attached Files Attached Files

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