How can I make this Pace formula neater?

**Tom B** · 09-27-2008, 11:34 PM

Hi there,

I've recently started training for a 10k run and I want to make a formula that would tell me how long it's taking to run each km during any given training run.

I've made this formula - it uses the Analysis Tookpak add in and when I made it I wanted to try and keep it in just one cell.

=INT(CONVERT(INT(((INT(B1)*60)+(100*(B1-INT(B1))))/A1),"sec","mn"))+((CONVERT(INT(((INT(B1)*60)+(100*(B1-INT(B1))))/A1),"sec","mn")-(INT(CONVERT(INT(((INT(B1)*60)+(100*(B1-INT(B1))))/A1),"sec","mn"))))*60)/100

A1 = number of KM
B1 = time in minutes and seconds (eg 6.30)

It works but I'm sure there must be a better way - any thoughts?

Thanks

**shg** · 09-28-2008, 12:22 AM

Please read the Forum Rules about thread titles, and then edit yours to be descriptive of your problem.

**shg** · 09-28-2008, 01:47 PM

If distance is in A2, and time (entered as time) is in B2, then the pace is =B1/A1.

For example,

      --A-- ---B--- ---C--- ----D-----
  1   Dist   Time    Pace    Formula  
  2   26.00 2:04:26 0:04:47 C2: =B2/A2

How can I make this Pace formula neater?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How can I make this Pace formula neater?

Thread Information

Users Browsing this Thread

Similar Threads

Convert text to formula.

I want to make a drop down list that will change a formula

Psychologist trying to make custom formula for my evaluations.

How to make a cell invisiable without deleting the formula.

Editing a formula to make references absolute

Bookmarks

Bookmarks

Posting Permissions