Forum Discussion
PLEASE HELP ME!!! Problem With Excel Formatting Not Working?
PLEASE HELP ME!!! I created an excel workbook for tracking fitness workouts, I record the data such as weight lifted, number of reps, and rest times between sets. I formatted the cells so they expres...
EDIT Duplicate of PLEASE HELP ME. Excel Time Formatting Not Working? | Microsoft Community Hub where existing replies say +/- the same thing
Why do some of the numbers like 28:44 transform into a complete different number when I enter them?
Not sure how many times this question has been answered on this forum and others (all have a Search button/icon)... Please carefully review the pink and green tables and you'll understand the Why:
Has shown in the blue table, if you apply Custom. Format [h]:mm you will get the desired display of i.e. 28:44 when entering 28:44 (instead of 00:28:44) - However, the actual duration will remain 1day, 4hrs and 44mins