Converting hours:minutes:seconds to just minutes
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. |
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 |
Converting hours:minutes:seconds to just minutes
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 wrote in message ... 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. |
Converting hours:minutes:seconds to just minutes
orMore long winded =ROUND(HOUR(A14)*60+MINUTE(A14)/24,0) -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=562250 |
All times are GMT +1. The time now is 06:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com