I have the following columns
Run Hours | Startup Total | Downtime Total | Operating Hours
24 2:00 1:35
I am trying to solve operating Hours
The problem is that Run Hours is formatted as a number (i can not change the format as this info comes from other worksheets as data entry) Startup Total and Downtime Total are formatted as [h]:mm and these totals come from other worksheets. To change formating of any of these cells would require extensive rework
The operating hours should be 24 - 2:00 - 1:35 = 21:25 hours formatted as [h]:mm
How do i subtract the hours from the Number and get the right number of hours?