Forum Discussion

BBBC1980's avatar
BBBC1980
Copper Contributor
May 21, 2019

Converting hours:minutes to minutes

Thanks in advance.  I can't find how to convert 2:55 to minutes.  I'm designing a data collection sheet and i have figured out how to deduct the start time from the finish time to give an elapsed time formatted as 2:55.  How do I convert this to 175 minutes?

excel

5 Replies

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    May 21, 2019

    BBBC1980 

    If, for some reason, you choose not to rely upon the knowledge that times and durations are represented as fractions of a day, you could use the longer formula

    = 60*HOUR(Duration) + MINUTE(Duration)

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    May 21, 2019
    Use this formula and format it as General:
    =E5*24*60