New answers tagged date-time
2
votes
Accepted
How do I get the sum of hours:minutes in MS Excel in the status bar and in a formula if the cells come in with a text format?
To convert time in text format to normal time (numeric) you have two choices.
1. Text to Columns (old way)
Data > Text to Columns - one column at a time
Output:
2. Office clipboard (new way)
Copy-...
- 2,225
1
vote
How do I get the sum of hours:minutes in MS Excel in the status bar and in a formula if the cells come in with a text format?
Make a new helper column and multiply all values with 1:
And the status bar and the formula work:
- 2,331
2
votes
How do I get the sum of hours:minutes in MS Excel in the status bar and in a formula if the cells come in with a text format?
Three things:
If the Status Bar shows a Count instead of a Sum, then the data is text, not numeric.
If a SUM() function returns 0, the input is text, not numeric.
The default number orientation is to ...
- 22.8k
Top 50 recent answers are included