Is there a way to convert a time that is formatted like this: hh:mm:ss into
total minutes (mm)?

Example: the time is 3:30:22. I want to convert that into 210 minutes (3
hours plus 30 minutes = 210 minutes) while rounding off the seconds?

Thanks!

Hi
=ROUND(A1*24*60,0)
and format as 'Number'

or try the custom format
[mm]

--
Regards
Frank Kabel
Frankfurt, Germany
"bob" schrieb im Newsbeitrag
...
Is there a way to convert a time that is formatted like this: hh:mm:ss
into
total minutes (mm)?

Example: the time is 3:30:22. I want to convert that into 210 minutes (3
hours plus 30 minutes = 210 minutes) while rounding off the seconds?

Thanks!

Bob,

If you don't need to use the minutes, use the custom format [mm]

Otherwise, use a formula

=Round(A1*24*60,0)

HTH,
Bernie
MS Excel MVP

"bob" wrote in message
...
Is there a way to convert a time that is formatted like this: hh:mm:ss
into
total minutes (mm)?

Example: the time is 3:30:22. I want to convert that into 210 minutes (3
hours plus 30 minutes = 210 minutes) while rounding off the seconds?

Thanks!

=ROUND(A1*1440,0)

HTH
Jason
Atlanta, GA

-----Original Message-----
Is there a way to convert a time that is formatted like
this: hh:mm:ss into
total minutes (mm)?

Example: the time is 3:30:22. I want to convert that
into 210 minutes (3
hours plus 30 minutes = 210 minutes) while rounding off
the seconds?

Thanks!
.