Minute Conversion

[Guest]

We are given a report that is showing a sum hours and minutes like this
00:23:00 like hh:mm:ss. First I need to now how to convert that into
minutes in decimel format such as 45.67 min. I then need to be able to add
subtract and multiply theses numbers.. I have tried all of the conversion
formulas and have had no luck.. Help please

BOb

 

[Dave Peterson]

Take the cell that holds that sum and use a formula like:

=A23*24*60

(A23 held the sum in my sample)

And format as General (or number with 2 decimal places).

or directly:
=sum(a1:a22)*24*60

 

[Guest]

It works great but why the 24?

Thanks

Take the cell that holds that sum and use a formula like:

=A23*24*60

(A23 held the sum in my sample)

And format as General (or number with 2 decimal places).

or directly:
=sum(a1:a22)*24*60

 

[Dave Peterson]

One hour is 1/24 of a day.

It might be easier to look at it in reverse.

To convert 45 minutes (45.00) to a time,
you'd divide 45 by 60 to get 3/4 of an hour.

To convert that to a time
You'd divide 3/4 by 24
3/96 of a day.

Then format as hh:mm:ss

So

45/60/24 = hh:mm:ss
which means that

45 = hh:mm:ss * 24 * 60

(not too fancy algebra <vbg>)