+ Reply to Thread
Results 1 to 2 of 2

Dividing Time

  1. #1
    Registered User
    Join Date
    02-11-2004
    Posts
    56

    Dividing Time

    I have one cell with a sum of time reduced by allowing staff to leave early on days where we're slow. I'm using the custom format [h]:mm. All I want to do is divide that number by 37.5 hours and I'm having a fair bit of trouble. Any pointers on what formula and/or syntax I should be using? I've tried simply doing =A1/37.5 but the result I'm getting back is not correct.

    I'm looking to have the result represented as a number w/ 2 decimal places to indicate the FTE (Full Time Equivalent = 37.5 hours per week) we've saved.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Try either

    =A1*24/37.5

    or

    =A1/"37:30"

    format as number

+ 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