It has to do with how Excel stores times internally. I could go into a lengthy discussion about how Excel stores time values but instead I’ll just tell you how to fix it. Change the format of column E to a decimal number and change the formulas in column E to “=(D2-C2)*24”. This will give you a decimal representation for the hours. If you need to see the actual minutes or want an in depth explanation let me know.
Menu