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.

Huawei P10 review

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

How VR is being used to simulate space

New iPad, iPhone SE & Red iPhone 7 on sale now