Who know's how to convert hours/mins into mins ?

  cstirrat 15:04 31 Jul 2009

E.g 02:19:41 into 139mins in Excel

  brambles 15:38 31 Jul 2009

I don't think it will be easy if you format h:min:secs.

If it's important and you want a simple arithmetic way to do it here goes

Head 3 columns Hours Minutes Seconds
Enter your 2 19 41 in these
Leave a column blank
Assume 2 is in A1 then A1*60 Column 5
Assume 19 is in B1 then =B1 Column 6
Assume 41 is in C1 then =C1/60 Column 7

Column 8 would be =addition of Column 5 6 7

(Aged 78 - but it does work!

  VoG II 15:42 31 Jul 2009




if you don't want the fractional part.

  VoG II 15:44 31 Jul 2009

Format the result cell as Number.

  cstirrat 16:15 31 Jul 2009

Wonderful. Many thanks both. C.

  Boluwd 18:43 31 Jul 2009

Absolutely Far Out!
VoG™ you're a genius!
Now before I go mad, PLEASE explain why the conversion factor is 1440.

  woodchip 18:57 31 Jul 2009

Good old calculator is as good as anything

  VoG II 19:03 31 Jul 2009

Excel stores times as numbers, 1 = 24 hours, 0.5 = 12 hours and so on.

There are 60 x 24 = 1440 minutes in a day so multiplying an Excel time by 1440 gives the number of minutes as a decimal.

  Boluwd 20:01 31 Jul 2009

Many thanks VoG™.

Makes sense,...........now I can put my brain into relax mode, open the wine and watch Wigan v Saints.

Have a good weekend everyone!

  Simsy 20:15 31 Jul 2009

an even easier way...

Just format the cell in question with the custom format;

note the square brackets.
You can then, if you want, enter the time in the way you've indicated, eg, 02:19:41 and it will display as shown.

Note that this truncates the seconds for display purposes, but keeps them for calculation purposes...
02:19:41 would be displayed as 139
02:19:19 would also be displayed as 139

adding them together gives 279, (correctly, because it's included the seconds), not 278



This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5T review: Hands-on

See the Best Button Badge Designs of 2017

iPhone X review

Black Friday 2017 : date, sites participants & bonnes affaires