• 508K Members
• 3,893 Online
• 605K Conversations

New Contributor

# 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?

5 Replies

# Re: Converting hours:minutes to minutes

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

# Re: Converting hours:minutes to minutes

Thanks Twifoo, much appreciated.

# Re: Converting hours:minutes to minutes

@BBBC1980, you're welcome.

# Re: Converting hours:minutes to minutes

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)

# Re: Converting hours:minutes to minutes

Thanks @Peter Bartholomew much appreciated.

Related Conversations
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies