Hi!
I would like to make a hour list at my workplace. So, every day I write down how many hours I've been working. My problem is, when I'm summing up the hours, (=SUMMER(D7:D36)), Excel thinks of this number as a time of day, e.g. if I have worked for 32 hours, the summary sais 08:00. What to do? (I use the format TT:MM in the summary cell.)
Bookmarks