+ Reply to Thread
Results 1 to 2 of 2

need form to calc EG :13:13 to 14:01 = td x 12 = miles-- multiple.

  1. #1
    waynehc
    Guest

    need form to calc EG :13:13 to 14:01 = td x 12 = miles-- multiple.

    eg
    Time place Time Place Diff
    13:01 psc 14.01 midd 1:00
    15:23 psc 16:24 midd 1:01
    17:42 midd 19:23 psc 2:19
    =total hrs-mins
    x by 12 = miles

    Need to calc the between 13:01 & 14:01 then the diff in time next entry
    Then give Add the two time diffs X by 12 to give me miles

  2. #2
    Gary Brown
    Guest

    Re: need form to calc EG :13:13 to 14:01 = td x 12 = miles-- multiple.

    Assuming =total hrs-mins is in E5, I think the formula you're looking for
    would be ...
    =(HOUR(E5)*12)+(MINUTE(E5)/60*12)

    1:00 + 1:01 + 2:19 = 4:20
    4 x 12 = 48
    20/60 x12 = 4
    Therefore = 52 miles

    HTH,
    Gary Brown


    "waynehc" <waynehc@discussions.microsoft.com> wrote in message
    news:3795294E-803D-49D5-978B-2740329D6117@microsoft.com...
    > eg
    > Time place Time Place Diff
    > 13:01 psc 14.01 midd 1:00
    > 15:23 psc 16:24 midd 1:01
    > 17:42 midd 19:23 psc 2:19
    > =total hrs-mins
    > x by 12 = miles
    >
    > Need to calc the between 13:01 & 14:01 then the diff in time next entry
    > Then give Add the two time diffs X by 12 to give me miles




+ 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