Forum Discussion
Solved
Time data issues
Hello all, As I mentioned in my first post, I am a complete novice with Excel, so I will probably be here often. I am having a terrible time working with elapsed time data. I’m trying to enter t...
Hi Rick,
it looks like that some entries were e.g. entered as text and preserves that even after having changed the format to e.g. [h]:mm. Please e.g. double click the value and press Enter. Will then change the value to a time value (appears then as e.g. 15:53:00 in the formula bar).
Best,Mourad
Thanks Mourad, that worked for that specific cell, but why do the cell entries in both rows 7 and 11 show a combination of text entries and time entries when both rows are formatted as time? I don't understand that at all.
Thanks again for your help,
Rick Lizotte
Hi Rick,
it looks like that some entries were e.g. entered as text and preserves that even after having changed the format to e.g. [h]:mm. Please e.g. double click the value and press Enter. Will then change the value to a time value (appears then as e.g. 15:53:00 in the formula bar).
Best,
Mourad
Thanks Mourad, that did the trick. I had no idea the formatting didn't apply immediately.
You've been a big help. Thanks again.
Rick Lizotte