-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How do I calculate cell values or contents in Excel?
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 65,166
- Office Version
- 365
- Platform
- Windows
Welcome to the MrExcel board!
I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with. It would also clarify for us whether those times are actual times (numbers) or text values.
In the interim try each of these structures
I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with. It would also clarify for us whether those times are actual times (numbers) or text values.
In the interim try each of these structures
Excel Formula:
=COUNT(W5:AG5)
Excel Formula:
=COUNT(W5:AG5+0)
Upvote
0
