Time Conversion Formula

[markoakes]

In column a I have time in the format of Hours:Minutes:Seconds (33:42:28). I need a formula to convert this to Rounded Minutes. So 33:42:28 would convert to 2022 minutes.

 

[AlphaFrog]

Try something like this...

=ROUND(A1*24*60,0)

 

[shg]

=round(a1*1440, 0) and format as General

 

[markoakes]

Thanks, worked great.

 

[Rick Rothstein]

I know you said "rounded minutes", but I thought you might want to see the following formula anyway... it does not round the seconds after 30 seconds upward, rather, the seconds are simply "thrown away".

=--TEXT(A1,"[m]")