Link to home
Start Free TrialLog in
Avatar of agwalsh
agwalsh

asked on

Weird problem with time calculations. Sum won't work. Plus will.

In the attached file, if I try to add up the times using Autosum (A36) I get 0. If I add them up using +, (B2), I can add them up...anyone got any ideas as to what this might be?
odd_time_calculations.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Professor J
Professor J

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of agwalsh
agwalsh

ASKER

Well, blow me down with a feather. I checked and the text to columns worked beautifully. Thank you.
Avatar of agwalsh

ASKER

A superb answer to an annoying question...thank you :-)
you are welcome agwalsh.