• 396K Members
• 8,425 Online
• 429K 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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies