In Excel, how do I display a leading zero? e.g. 05 for 5 ?
Am using Excel to calculate a pace-per-mile for runners, starting with "miles
per hour". 7 mph is an eight minute and 34 second "pace per mile". I start with 7.0 mph in the initial column, and can easily calculate the 8:34. But 6.6 mph is 9 minutes and 5 seconds per mile, which I can calculate. I have the 9 in one column and the 5 in another, and use CONCATENATE to display it as 9:5. But I want it to display as 9:05, not 9:5. How do I get that leading zero in there? |
In Excel, how do I display a leading zero? e.g. 05 for 5 ?
If A1: (miles per hour.....eg 6.6)
This formula, formatted as Time (mm:ss), returns the minutes per mile: B1: =1/(A1*24) In the above example, B1 displays: 09:05 Is that something you can work with? Regards, Ron Coderre Microsoft MVP (Excel) "kenkirs" wrote in message ... Am using Excel to calculate a pace-per-mile for runners, starting with "miles per hour". 7 mph is an eight minute and 34 second "pace per mile". I start with 7.0 mph in the initial column, and can easily calculate the 8:34. But 6.6 mph is 9 minutes and 5 seconds per mile, which I can calculate. I have the 9 in one column and the 5 in another, and use CONCATENATE to display it as 9:5. But I want it to display as 9:05, not 9:5. How do I get that leading zero in there? |
All times are GMT +1. The time now is 05:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com