Hi all,
Please see the attached so you can properly mock me. I am working on an hours log to track hours worked. If you look at the yellow highlighted bit, the math doesn't make sense. When I change the formatting for time used it becomes .14 which I cannot figure out how it gets. If I play with other numbers, I get 20.40. The number the time remaining should reflect is 28.8.
I'm embarrassingly stumped here. I am trying to help a coworker and have tried everything I can think of from making a file from scratch in case it was a formatting issue, playing with numbers, formulas, formatting, etc. I even played with the calculator to try to figure out where the numbers are coming from. It should be a simple issue but I'm going crosseyed. I think I just need a second set of eyes. Help please!?
Bookmarks