As I asked before, why go to the bother of writing and displaying the text function? Just have the equation =C5-B5 and format as "h:mm". Times and dates are nothing more than floating point numbers (e.g. July 9, 2014 8:32am = 41829.35581). Why not just use those numbers instead of adding all that unnecessary complexity?

I have attached a sheet with the first week. Without any familiarity with your time keeping system, I don't understand exactly what the purpose is for some of the columns.

And what I said about unnecessary complexity become clear with your equations for columns K-M. K seems to be a running total of hours worked but for some reason, K7 has an added term.

Attached Files

June 2014.xlsm (15.8 KB, 22 views)