SOLVED

transform hours into minutes

%3CLINGO-SUB%20id%3D%22lingo-sub-1447036%22%20slang%3D%22de-DE%22%3Etransform%20hours%20into%20minutes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447036%22%20slang%3D%22de-DE%22%3E%3CP%3EHow%20can%20I%20transform%2026%3A08%20hours%20into%20minutes%20on%20excel%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1447036%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1447061%22%20slang%3D%22en-US%22%3ERe%3A%20transform%20hours%20into%20minutes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447061%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F691680%22%20target%3D%22_blank%22%3E%40lolo123%3C%2FA%3E%26nbsp%3B%20that%20may%20depend%20on%20how%20that%20time%20is%20stored.%26nbsp%3B%20For%20example%20if%20it%20is%20text%20then%20you%20may%20need%20to%20parse%20the%20text%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3D--LEFT(A1%2CSEARCH(%22%3A%22%2CA1)-1)*60--MID(A1%2CSEARCH(%22%3A%22%2CA1)%2B1%2C2)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20it%20is%20a%20number%20and%20in%20excel%20date-time%20format%20then%20you%20need%20to%20convert%20it%20into%20just%20mins%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DA1*24*60%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20that%20assumes%20the%20'Date'%20part%20of%20the%20Date-Time%20is%20not%20set%20therefore%200%2C%20which%20based%20on%20your%20example%20it%20is%20almost%20certainly%20true%20(or%20it%20is%20text).%26nbsp%3B%20If%20you%20do%20have%20date%20and%20time%20information%20(e.g.%206%2F5%2F2020%209%3A35%20am)%20you%20would%20need%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DHOUR(A1)*60%20%2B%20MINUTE(A1)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Efinally%2C%20note%20that%20these%20results%20should%20all%20be%20formatted%20as%20general%20or%20number%20and%20not%20time%20as%20these%20formula%20convert%20to%20a%20raw%20count%20of%20the%20number%20of%20minutes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1448192%22%20slang%3D%22de-DE%22%3ERe%3A%20transform%20hours%20into%20minutes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1448192%22%20slang%3D%22de-DE%22%3EI%20know%2C%20but%20when%20I%20do%20it%20with%20the%20formula%20%22%3DHOUR(A1)*60%20%2B%20MINUTE(A1)%22%20I%20get%20128%20min%20because%20the%20time%20period%20is%20more%20than%2024%20hours%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1448391%22%20slang%3D%22en-US%22%3ERe%3A%20transform%20hours%20into%20minutes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1448391%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F691680%22%20target%3D%22_blank%22%3E%40lolo123%3C%2FA%3E%26nbsp%3B%20did%20you%20try%20the%20middle%20formula%20(%3DA1*24*60)%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

How can I transform 26:08 hours into minutes on excel?

3 Replies
Highlighted

@lolo123  that may depend on how that time is stored.  For example if it is text then you may need to parse the text 

 

=--LEFT(A1,SEARCH(":",A1)-1)*60--MID(A1,SEARCH(":",A1)+1,2)

 

if it is a number and in excel date-time format then you need to convert it into just mins

 

=A1*24*60

 

but that assumes the 'Date' part of the Date-Time is not set therefore 0, which based on your example it is almost certainly true (or it is text).  If you do have date and time information (e.g. 6/5/2020 9:35 am) you would need:

 

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

finally, note that these results should all be formatted as general or number and not time as these formula convert to a raw count of the number of minutes.

 

Highlighted
I know, but when I do it with the formula "=HOUR(A1)*60 + MINUTE(A1)" I get 128 min because the time period is more than 24 hours
Highlighted
Best Response confirmed by lolo123 (New Contributor)
Solution

@lolo123  did you try the middle formula (=A1*24*60) ?