I have a weekly data report that is generated with one column containing how long a given task took (in hours) and I need switch that to minutes and then I need to discover the percentage time of the week (business days so 7200 minutes) it took to complete the task.

I converted the hour to minutes by just going to Format-->Number and doing a custom entry of [m], but when I type in the simple formula to get the percentage =A2/7200 I'm coming back with very faulty data.

The problem I'm encountering seems to stem from the fact that even though my time column visibly appears to have changed to minutes when I click on a cell and look in the formula bar it reads as "1/3/1900 1:30:53 PM" (the serial date I believe?) and then my average formula is using that to calculate the percentage, which is not working at all.

Is there a way I can make the time presented to me as the serial date have the actual minute value so I could use the data in a formula?