Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel Time Calculations
In the meantime, I've done it! If you use the 1904 date system, it works. See: www.pcworld.com/resource/article.asp?aid=7222. Thanks for your replies.- CarFleet
- Post #6
- Forum: Microsoft: Office
-
Excel Time Calculations
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...- CarFleet
- Post #3
- Forum: Microsoft: Office
-
Excel Time Calculations
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...- CarFleet
- Thread
- Replies: 7
- Forum: Microsoft: Office
