当前位置: 动力学知识库 > 问答 > 编程问答 >

Calculate a duration using excel

问题描述:

I'm working with a column that has a duration in the format hh:mm:ss. How can I calculate the number of minutes, with a minimum of one? So 00:00:30 = 1 , 00:01:20 = 2 and so on?

网友答案:

Time is a decimal portion of the day, use this:

=ROUNDUP(A1*60*24,0)

分享给朋友:
您可能感兴趣的文章:
随机阅读: