+ Reply to Thread
Results 1 to 2 of 2

Calculations Involving Durations in hh:mm, NOT Times

  1. #1
    Registered User
    Join Date
    06-20-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    1

    Calculations Involving Durations in hh:mm, NOT Times

    Hello,

    I am in charge of statistics at a virtual air traffic control organization (VATSIM.net if you want to learn more). We have a network on which members' session durations are tracked in hh:mm. I was wondering if there was a way that I could input those session durations into a cell next to their name, input their totals for last month in the field next to it, and then use an IF statement as such: IF([cell containing this month's online time]-[cell containing last month's online time]=>0,"Up","Down"). The idea is that if this month's online time exceeds last month's online time, a third cell echoes (using PHP terms here...hehe) "up," and if not, "down," meaning their online time increased this month.

    The part on which I am confused is how to format and use durations, not time, in hh:mm. Excel seems to want to use, for instance, 12:00 (which would be twelve hours and zero minutes) as 12:00 P.M.. I just want it to indicate twelve hours, not twelve o'clock. Similarly, 67:00 would be sixty-seven hours, not an imaginary 67 o'clock.

    Many thanks!

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Calculations Involving Durations in hh:mm, NOT Times

    Times of day and time durations are the same thing in Excel. If you don't want to see AM/PM, format as [h] or [h]:mm.

    You can add and subtract normally, but Excel will not display negative times as a time.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

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