+ Reply to Thread
Results 1 to 2 of 2

Turning a set amount of hours into days

  1. #1
    Registered User
    Join Date
    09-16-2008
    Location
    UK
    Posts
    11

    Turning a set amount of hours into days

    Bad thread title but I really couldn't think of a better one/how to explain it!

    Basically, I am trying to create a spreadsheet that records the shifts that people work and to calculate sickness, overtime etc. I am recording each shift in hours (7.5 per shift). However, the person asking for the spreadsheet needs annual leave recorded in days.

    How can I make excel know that 7.5 hours = 1 day?

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Turning a set amount of hours into days

    why can't you take the hours and divide by 7.5 and round it off.
    what happens to partial days? if the hours are say 17, you would get 2.67 days.
    If it's not that simple, attach a sample to show what results you are expecting.
    modytrane

+ Reply to Thread

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