Results 1 to 8 of 8

Convert server downtime to Uptime in Hours for whole month

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2016
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    MS Office 2013
    Posts
    5

    Red face Convert server downtime to Uptime in Hours for whole month

    New to the site and new to excel so hope someone can help. I have downtime start date to downtime end date, which generated by system.

    I would like a way to record on a daily basis what the uptime has been for each server and then to record the same for that month in a hours… The time always started at 6.00 AM to 6.00 AM next day everyday. Maybe you could edit the attached file for more clear understanding on my problem.

    Appreciate if someone can guide me.

    Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Server Uptime/Downtime Calculation
    By rovert.natsud in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-13-2018, 12:28 PM
  2. [SOLVED] Calculating Downtime During Hours of Operation
    By Puni in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-01-2018, 11:00 PM
  3. Downtime Tracking between Multiple Days Only Counting Working Hours
    By TandCsMom in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2014, 05:24 PM
  4. Help with creating uptime/downtime calculation/analysis
    By buerm009 in forum Excel General
    Replies: 0
    Last Post: 02-19-2013, 02:24 PM
  5. [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
  6. Replies: 8
    Last Post: 03-19-2009, 11:01 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