Take the 2-minute tour ×  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.  share|improve this question If it is over 24 hours,
what format are hoping to see? 28:30 for a 28 and half hour job?
–  lionz Jun 20 '11 at 17:29 Yes, lionz, I would expect to see
28:30 for 28 and 1/2 hours. –  HK1 Jun 20 '11 at 18:53 please
don't forget to accept the answer if that fits what you asked.
Or else, please tell u