converting hrs to minutes

  • Thread starter Thread starter Jerome Ranch
  • Start date Start date
J

Jerome Ranch

I have a large database with values in hrs (i.e. 1:06, 123:45, 345:56
etc) I want to convert these to minutes (1:06 to 68, 123:45 to 7425
etc).
I've been fooling with the convert and format functions but haven't
gotten anywhere.
Help would be appreciated.
Jerry
 
If your time values are in column A, type = A1*1440 in column B1 , then copy
down
Format B1 as Standard

HTH
 
Jerome

Format/cells/custom [mm]

no formula needed exc. perhaps reference the original time elapsed cell (=b2
or whatever)

Beege
 
Thanks
Your suggestions worked great.
I was trying to get too cute with functions
Jerry
 
One way:

Since XL stores times as fractional days, just multiply by 24*60:

A1: 123:45
A2: =A1*1440 ===> 7425

when formatted as General. Note that 1:06 --> 66 minutes, not 68.
 
Back
Top