Calculated Fields

by camel

Downloads: 23,628 (9) • Reviews: 4

Version:

1.2.9.4

Updated:

Apr 11, 2011

Convert seconds to hours and minutes

Convert seconds to hours and minutes

Postby andy1608 » Fri Apr 01, 2011 7:39 am

I have used the formula {RANGEELAPSED(HR,162,168)} to identify how long I spend in this zone. How would I convert the answer to hours and minutes without going into decimal time?
andy1608
Donated!
Donated!
 
Posts: 8
Joined: Fri Jan 08, 2010 1:37 pm

Re: Convert seconds to hours and minutes

Postby camel » Mon Apr 11, 2011 12:42 pm

Just calculate your result in seconds. And than you can fill this value into custom field with Type set to Elapsed Time. And sporttracks will show you time in hourst minutes etc automatically.
camel
Donated!
Donated!
 
Posts: 363
Joined: Tue May 18, 2010 7:14 am
Location: Slovakia

Re: Convert seconds to hours and minutes

Postby simmern » Mon Jan 02, 2012 6:16 am

I found this thread and it helped out in some formulas for me.

I have an formula as {RANGEPACE(HR,140,150)}

would like to get it in hh:mm:ss,0 or mm:ss or mm:ss,0 how do I do that?
simmern
 
Posts: 28
Joined: Mon Feb 15, 2010 4:03 am


Return to Calculated Fields

Who is online

Users browsing this forum: No registered users and 1 guest

cron