ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula to show non decimal hours (https://www.excelbanter.com/excel-discussion-misc-queries/120594-formula-show-non-decimal-hours.html)

colgar65

Formula to show non decimal hours
 
How do I get a formula to add up over the hour mark not using :

IE

1.01 + 0.59 = 1.01 hours not as adds up to 1.61


All times are GMT +1. The time now is 06:50 AM.

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