SOLVED

transform hours into minutes

Copper Contributor

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

3 Replies

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

 

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
best response confirmed by lolo123 (Copper Contributor)
Solution

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

 

1 best response

Accepted Solutions
best response confirmed by lolo123 (Copper Contributor)
Solution

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

 

View solution in original post