Converting hours:minutes to minutes

Copper Contributor

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?

5 Replies
Use this formula and format it as General:
=E5*24*60

Thanks Twifoo, much appreciated.

@BBBC1980, you're welcome.

@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)

Thanks @Peter Bartholomew much appreciated.