+ Reply to Thread
Results 1 to 8 of 8

Calculate the time elapsed since windows started

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Calculate the time elapsed since windows started

    Hello everyone
    I need to know the time elapsed since the windows started ..
    Thanks advanced
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Calculate the time elapsed since windows started

    As an Excel question, do you mean since the Excel macro started? Or are you trying to figure out when the PC was last booted?
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Calculate the time elapsed since windows started

    Thanks sir for reply
    I'm trying to figure out when the PC last booted?

  4. #4
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Calculate the time elapsed since windows started

    Maybe :

    Please Login or Register  to view this content.

  5. #5
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Calculate the time elapsed since windows started

    A quick Google search seems to imply adding this function to your workbook:
    Please Login or Register  to view this content.
    Then add this function I wrote as well, this can be used from a cell formatted as date/time: m/d/yyyy h:mm
    Please Login or Register  to view this content.
    In a cell as =LastBootTime()

  6. #6
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Calculate the time elapsed since windows started

    Mr. Karedog
    That's perfect solution. Thanks a lot for sharing it

    Mr. JBeaucaire
    Thank you very much but I got incorrect results
    I tried this and it is ok

    Please Login or Register  to view this content.
    Last edited by YasserKhalil; 10-08-2015 at 02:47 PM.

  7. #7
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Calculate the time elapsed since windows started

    My apologies, yes, your version gives time elapsed, mine gives the exact date/time of the last boot.

  8. #8
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Calculate the time elapsed since windows started

    Never mind .. no need for apologies at all.. You are awesome ..
    Thanks a lot for this great help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to calculate time elapsed in 2 datetimes?
    By jamiguel77 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-10-2013, 06:19 PM
  2. Can't seem to calculate elapsed time?
    By homer09001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2013, 08:12 AM
  3. Replies: 2
    Last Post: 04-27-2011, 08:21 AM
  4. Calculate elapsed time by now() ?
    By Desiv5 in forum Excel General
    Replies: 5
    Last Post: 05-07-2010, 05:16 AM
  5. calculate elapsed time
    By Tiresias in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2008, 12:52 AM
  6. Calculate Elapsed Date and Time
    By Gary F Shelton in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-11-2006, 11:10 PM
  7. [SOLVED] calculate elapsed time between dates and times
    By Jenna in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2006, 12:45 PM
  8. [SOLVED] Ref: Formula to calculate elapsed time between certain dates and t
    By DrBarqs in forum Excel General
    Replies: 2
    Last Post: 11-18-2005, 07:20 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