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!
|