Custom format the total cell to [h]:mm:ss

Right clickFormatCellsCustom

If this post helps click Yes
---------------
Jacob Skaria


"Jason" wrote:

I have hours employees have worked over periods of days, weeks and months.
I need to add times and get an answer that makes sense.
Because sometimes in the one cell the answer may equate to less than or
greater than 24hrs in any given day / week / month I need a formulae,
function or format that I can work with effectively.
I have tried IFing it, but because of the format it doesn't work out.