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

1. ## 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  Register To Reply

2. ## 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  Register To Reply