Home

Converting hours:minutes to minutes

%3CLINGO-SUB%20id%3D%22lingo-sub-632190%22%20slang%3D%22en-US%22%3EConverting%20hours%3Aminutes%20to%20minutes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-632190%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20in%20advance.%26nbsp%3B%20I%20can't%20find%20how%20to%20convert%202%3A55%20to%20minutes.%26nbsp%3B%20I'm%20designing%20a%20data%20collection%20sheet%20and%20i%20have%20figured%20out%20how%20to%20deduct%20the%20start%20time%20from%20the%20finish%20time%20to%20give%20an%20elapsed%20time%20formatted%20as%202%3A55.%26nbsp%3B%20How%20do%20I%20convert%20this%20to%20175%20minutes%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-632190%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-632350%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20hours%3Aminutes%20to%20minutes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-632350%22%20slang%3D%22en-US%22%3EUse%20this%20formula%20and%20format%20it%20as%20General%3A%3CBR%20%2F%3E%3DE5*24*60%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-632365%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20hours%3Aminutes%20to%20minutes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-632365%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Twifoo%2C%20much%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-632440%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20hours%3Aminutes%20to%20minutes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-632440%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F346233%22%20target%3D%22_blank%22%3E%40BBBC1980%3C%2FA%3E%2C%20you're%20welcome.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-632444%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20hours%3Aminutes%20to%20minutes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-632444%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F346233%22%20target%3D%22_blank%22%3E%40BBBC1980%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%2C%20for%20some%20reason%2C%20you%20choose%20not%20to%20rely%20upon%20the%20knowledge%20that%20times%20and%20durations%20are%20represented%20as%20fractions%20of%20a%20day%2C%20you%20could%20use%20the%20longer%20formula%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D%2060*HOUR(Duration)%20%2B%20MINUTE(Duration)%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-635993%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20hours%3Aminutes%20to%20minutes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-635993%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3Bmuch%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E
BBBC1980
New 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.

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