Results 1 to 4 of 4

Convert hours to Years, Months, Weeks, Days and Hours

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,065

    Convert hours to Years, Months, Weeks, Days and Hours

    Trying to get a reasonable estimate. For my work, all my leave in the company systems is in terms of "Hours". So right now, for instance, I have 301.75 hours of vacation. So how much vacation do I have? 300.75/40. So that's about 7.5 weeks, or 37 workdays plus a little over 4 hours.

    But I also have a ton of sick leave, plus from time to time I get Admin leave, Special leave, etc.

    So, what I want, at any one time, is a way to see how much time I COULD take off if disaster strikes.

    My total balance today is 2,132.25 hours. By my calculations that's 12 months, 1 week, 1 day and 4.25 hours.
    I know "Months" is variable, so for my month value I use
    52 weeks per years*40 hours per week)/12 months per year
    My calcs are in the attached workbook, and they've done well for many years, but my totals are about to move into the Years category, so need my formulas to be able to handle the Year component. I'm also thinking by now there might be an easier way to achieve my goal, so would appreciate any ideas and any help you can provide.
    Attached Files Attached Files
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Convert a value that is in minutes to hours, days, weeks months, in decimal
    By sans in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-06-2022, 07:30 AM
  2. [SOLVED] Convert seconds to years, months, days, hours, minutes snd seconds
    By Tresfjording in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-14-2022, 12:55 AM
  3. [SOLVED] Calculating Years, Months, Week, Days, Hours, Minutes for Work Days between two dates
    By hecgroups in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-23-2019, 12:09 AM
  4. Replies: 5
    Last Post: 10-21-2017, 10:26 AM
  5. Convert a value to Years, Months, Days, Hours and Minutes
    By )3az_)3aziah in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-30-2017, 11:18 AM
  6. [SOLVED] Function or macro to convert string with weeks, days, hours, minutes to Hours
    By kknb0800 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2012, 11:35 AM
  7. Convert days -> Years, Months, Days, Hours, Minutes, Seconds
    By brharrii in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-06-2012, 06:44 PM

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