Is it possible to calculate minutes to hour in a spreadsheet or other software program?

Question

I am trying to figure out the easy way to convert minutes to hours. For example 20min +12min + 34min. I have tons of these problems. I am not sure this can be done in excel.

Answer 1

It can be done!

But its a brain twister:

First print these instructions off then go to Excel and do it in a blank sheet so you know what I'm talking about (you have to trick Excel - hee hee I have no life).

Enter your first number in A1, enter your second number in B1, enter your third number in C1.

Enter this formula in D1 to add your numbers:
=sum(A1:C1)

Enter this formula in E1 (we are retrieving the first number here).
=D1/60

Enter this formula in F1 (remove the number behind the decimal)
=rounddown(E1,0)

Enter this formula in G1 (retrieve the seconds)
=(E1-F1)*60

Now we hide two columns so we don't confuse the heck out of people...
Highlight column headers D & E (click on the D at the top and drag to E). Select Format, Column, Hide Columns.

Click on the F column header. Now we are going to fomat the first number so it has a colon behind it. Select Format, Cells and select the Number tab. Click on custom. Where it says Type type in 0: (that's a zero). Click OK.

Click on the G column header. Now we are going to format the second number so that numbers less than 10 have a zero in front of them. Select Format, Cells and select the Number tab. Click on custom. Where it says "Type" type in 00 (two zeros). Click OK.

Double click on the line between the G and H header to reduce the column width.

You're done. Now if you decide you want to subtract the numbers, multiply the numbers, etc. all you have to do is change your formula in column D1.

Cheers.

Answer 2

Well it is simple math so yes you can do it in excell. Heck you can do it with works for that matter.

All you need is to put in fields for the input of minutes. Put a total column for minutes then put a column in to convert minutes to hours.