问题描述
我需要创建一个Excel表来计算每日的培训时间.每行都有以下字段:日期，距离，时间和分钟数/公里.
我的主要问题是我想以mm:ss格式显示时间.例如:24分3秒应为24:03，但"Excel"将其设置为00:03:00(午夜后3分).我尝试设置特殊格式"，但仍然"Excel坚持"设置小时格式.而且，训练可能超过60分钟，而我仍然只希望将其作为mm:ss
我的第二个问题是在完成格式化问题之后，计算时间/距离的简单方法是什么?
I need to create and Excel table that computes daily training times. each row has the following fields: Date, Distance, Time and Minutes/Km.
My main problem is that I want to display the Time in format of mm:ss. For example: 24 min and 3 sec should be 24:03, but "Excel" turns it to 00:03:00 (3 min after midnight). I've tried setting up "special formatting" but still "Excel insists" on formatting the hours. More over, training may exceed 60 minutes and I still want it only as mm:ss
My second question is after I'm done with the formatting issue, what is the simple way to compute Time/Distance?
推荐答案
将值输入为0:mm:ss，格式设置为[m]:ss
enter the values as 0:mm:ss and format as [m]:ss
因为现在是分钟&秒，简单的算法即可让您计算统计信息
as this is now in the mins & seconds, simple arithmetic will allow you to calculate your statistics
这篇关于Excel 2007:如何不将mm:ss格式显示为DateTime(例如73:07)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！