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

  cstirrat 15:04 31 Jul 09
Locked

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

  brambles 15:38 31 Jul 09

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

Brambles
(Aged 78 - but it does work!

  VoG II 15:42 31 Jul 09

=A1*1440

or

=INT(A1*1440)

if you don't want the fractional part.

  VoG II 15:44 31 Jul 09

Format the result cell as Number.

  cstirrat 16:15 31 Jul 09

Wonderful. Many thanks both. C.

  Boluwd 18:43 31 Jul 09

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 09

Good old calculator is as good as anything

  VoG II 19:03 31 Jul 09

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 09

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 09

an even easier way...

Just format the cell in question with the custom format;
[mm]

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

Regards,

Simsy

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

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…