Convert time range into minutes formula

I need a formula that will convert time into minutes and round up 30 sec to 1 minute.

Example: change 7:58:31 (hr:min:sec) to 479 minutes or 08:31:29 to 511 minutes. The first example adds 1 minute to total because 31 seconds is over half a minute.

1 Answer

1440¹ is the magic number in this case

using ROUND to round up/down will give you the resolution. With your time in A1, =ROUND(A1*1440,0) will get you the number of minutes

with your calculation of =((HOUR(G11)*60)+MINUTE(G11)+(SECOND(G11)/60)), changing to =((HOUR(G11)*60)+MINUTE(G11)+IF(SECOND(G11)<30,0,1)) would remove the decimal

¹ 1440 is simply 24 hours * 60 minutes