View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default 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.