I guess this is two related questions in one question. I'm creating an Excel spreadsheet and I need to enter Qty of Time Spent in the format hh:mm in one cell and in another I'll be calculating the labor cost based on the hh:mm entered in the TimeQty cell. It's possible that TimeQty will exceed 24 hours on some projects so my solution needs to work for this.
It appears that all of Excel's time formats assume that you are referencing a specific date and time on the calendar, not an accumulation of Hours and Minutes.
Anyone have a suggested solution? I also need to be able to calculate hourly rates (or in this case, by the minute) using your suggested solution.