Results 1 to 24 of 24

Converting unusual time format

Threaded View

essee Converting unusual time format 09-17-2012, 10:54 AM
Jakobshavn Re: Converting unusual time... 09-17-2012, 11:38 AM
essee Re: Converting unusual time... 09-18-2012, 04:04 AM
Kevin UK Re: Converting unusual time... 09-17-2012, 12:25 PM
Kevin UK Re: Converting unusual time... 09-18-2012, 08:35 AM
essee Re: Converting unusual time... 09-18-2012, 09:30 AM
ChemistB Re: Converting unusual time... 09-18-2012, 10:16 AM
Jakobshavn Re: Converting unusual time... 09-18-2012, 10:18 AM
essee Re: Converting unusual time... 09-18-2012, 10:41 AM
ChemistB Re: Converting unusual time... 09-18-2012, 10:46 AM
essee Re: Converting unusual time... 09-18-2012, 10:50 AM
essee Re: Converting unusual time... 09-18-2012, 11:09 AM
Jakobshavn Re: Converting unusual time... 09-18-2012, 11:11 AM
essee Re: Converting unusual time... 09-18-2012, 11:16 AM
Jakobshavn Re: Converting unusual time... 09-18-2012, 11:21 AM
essee Re: Converting unusual time... 09-19-2012, 05:39 AM
Jakobshavn Re: Converting unusual time... 09-19-2012, 06:51 AM
daddylonglegs Re: Converting unusual time... 09-24-2012, 08:21 AM
Jakobshavn Re: Converting unusual time... 09-24-2012, 08:27 AM
daddylonglegs Re: Converting unusual time... 09-24-2012, 08:36 AM
  1. #1
    Registered User
    Join Date
    09-17-2012
    Location
    South Wales, UK
    MS-Off Ver
    Excel 2003
    Posts
    51

    Converting unusual time format

    I'm trying to calculate the downtime of some network kit using it's factory tools, but the exported report format for the time period is shown as (for example) "4d 15h 10m" for 4 days, 15 hours and 10 minutes.

    Is it possible to convert this format to either hh:mm or dd:hh:mm, so that I can calculate the SUM totals?

    Alternatively, if it helps, it also shows the start and end date/time of these periods in the following format:
    "Wednesday, September 12, 2012 18:53:17" so it might be possible to work out new downtime periods and use them instead.

    Many thanks in advance,
    Dave.
    Last edited by essee; 09-19-2012 at 05:39 AM.

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