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 express your rest times in terms of minutes and seconds (I used the custom "H:MM" format of time option). But whenever I record the amount of time you spend during cardio exercise, the formatting gets COMPLETELY SCREWED UP because when I type 28:44 (28 minutes and 44 seconds) of cardio duration, it instantly turns into 4:44 (4 minutes and 44 seconds). But if I type 20:00 (20 minutes) of cardio duration, it stays as 20:00 (20 minutes) and it never turns into something else. Why do some of the numbers like 28:44 transform into a complete different number when I enter them? I uploaded 3 screenshots below to better express what I mean.
1 Reply
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
