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-...
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
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 ...
Top 50 recent answers are included
Related Tags
date-time × 519microsoft-excel × 223
worksheet-function × 114
windows × 43
windows-10 × 43
windows-7 × 37
time × 35
linux × 34
microsoft-excel-2010 × 32
cell-format × 18
date × 17
ntp × 16
sync × 14
charts × 14
text-formatting × 14
timestamp × 13
macos × 12
clock × 12
time-zone × 12
command-line × 11
windows-xp × 10
vba × 10
microsoft-excel-2013 × 10
microsoft-excel-2007 × 9
formatting × 9