PC Review


Reply
Thread Tools Rate Thread

Converting hours:minutes:seconds to just minutes

 
 
=?Utf-8?B?RGFuIFZhZ2xl?=
Guest
Posts: n/a
 
      17th Jul 2006
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.
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      17th Jul 2006
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
 
Reply With Quote
 
Biff
Guest
Posts: n/a
 
      17th Jul 2006
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.



 
Reply With Quote
 
VBA Noob
Guest
Posts: n/a
 
      17th Jul 2006

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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need to convert 157.25 minutes, into hours, minutes and seconds. Al Microsoft Excel Misc 1 11th Mar 2009 09:04 AM
Convert Decimal Minutes to Hours-Minutes-Seconds Scott Microsoft Excel Programming 3 22nd Oct 2008 03:26 AM
Converting hours, minutes, seconds, to hours chouck Microsoft Excel Worksheet Functions 7 29th Jan 2008 08:00 PM
Quick help please! Converting seconds to hours and minutes. =?Utf-8?B?cHJlc2VudGluZyB0b21vcnJvdw==?= Microsoft Excel Misc 12 20th Sep 2004 11:15 PM
Converting seconds to hours/minutes/seconds Roger Microsoft Excel Worksheet Functions 3 13th Aug 2004 05:23 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:49 AM.