I understand what you mean by expanding the cell, but if I do that I just get more #.
The formula I have used is weekly total = 51:15:00 (which is the total hours for one week, subtracted from the tasrget of 37:00:00 which gives me 14:15:00. The problem is if the weekly total is less than...
I am trying to design a basic time recording spreadsheet.
I habve a morning start time, morning finish time, lunchtime then afternoon start and finish time. This is set against a target time of 37 hours per week. The times are formatted as [h]:mm:ss. If the week's time exceeds 37 hours, excel...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.