Results 1 to 9 of 9

SUMIF - Time Duration Issue?

Threaded View

  1. #1
    Registered User
    Join Date
    02-15-2013
    Location
    Port Hedland, Australia
    MS-Off Ver
    Excel 2007
    Posts
    10

    Angry SUMIF - Time Duration Issue?

    Hello,

    Attached is a spreadsheet that is recording machine downtime.
    As per summary table inserted above the data in the first 4 tabs (we are focussing on A, B, C and D Service downtime). I would like to retrieve total downtime within each month.

    Sadly I haven't been able to figure a formula that totals the time duration in column F (Total Down Time) as I believe it has transferred into excel as an incorrect format.
    I have tried formatting to [h]:mm:ss, however this doesn't seem to fix the issue.

    Any help greatly appreciated!!
    Attached Files Attached Files

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