问题描述:

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)

相关阅读:
Top