View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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