ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Formulas (https://www.excelbanter.com/excel-programming/338676-formulas.html)

RM

Formulas
 
How do I write a formula that if a number is greater than 40 hours (40:00:00)
it adds the number of hours(cells contents) to that 40 hours, and if it is
less than that 40 hours it will subtract a number (cell contents)? If anyone
can help I'd appreciate it as I am not that talented with Excel.


All times are GMT +1. The time now is 12:33 AM.

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