What happens in Excel when you add 2 time formatted cells:
Image:Formatting hours
Great, just what we wanted.
Now increase the hours in B1:
Image:Formatting hours
Oops. Not what we had in mind.
You can format C1 as 'd h:mm', but this will show as '1 2:15' (1 day and 2:15 hours).

But here's the nice thing, format it as [h]:mm and you get this:
Image:Formatting hours
I've used it before, many years ago. It's in the help somewhere, but hard to find.
Now you can add hours/minutes, and have it correctly displayed.

Category:  Microsoft  Excel  | TechnoratiTechnorati: ,

Comments (1)