ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   IS POSIBLE TO ADD TEXT IN TO A CELL WHIT TIME FORMAT? (https://www.excelbanter.com/excel-programming/379020-posible-add-text-cell-whit-time-format.html)

aloncillo

IS POSIBLE TO ADD TEXT IN TO A CELL WHIT TIME FORMAT?
 
i got a time sheet but wen a entry for example rest i get error value

NickHK

IS POSIBLE TO ADD TEXT IN TO A CELL WHIT TIME FORMAT?
 
Sounds like your code/formula is expecting a number, but you are entering
text, so bang....error.
Your code/formula needs to deal with it.
On the worksheet, maybe you ISERROR or code need error trap and/or data
check, IsNumeric .
Post what you have.

NickHK

"aloncillo" wrote in message
...
i got a time sheet but wen a entry for example rest i get error value





All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com