Converting hours:minutes:seconds to just minutes
You can multiply by 24*60
=A1*24*60
And format the result as General (or Number--just not time).
Or maybe just give it a custom format of [mm]
(but fractions of minutes will be hidden by the format)
Dan Vagle wrote:
I have a bunch of data that is in the following format: hours:minutes:seconds
For example:
3:23:14
5:20:45
8:10:20
How can i convert this into just minutes.
Thank You Very Much.
--
Dave Peterson
|