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.

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

Hi!

Format as [mm]:ss to get the result as time --- 203:14

Or, to get the result as a decimal number:

A1*1440 --- 203.2333

Biff

"Dan Vagle" <Dan (E-Mail Removed)> wrote in message
news:7E023F80-E510-46EB-99D4-(E-Mail Removed)...
>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.

orMore long winded

=ROUND(HOUR(A14)*60+MINUTE(A14)/24,0

--
VBA Noo
-----------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...fo&userid=3383
View this thread: http://www.excelforum.com/showthread.php?threadid=56225