Inframap
asked on
calculate hours with excel
Hello
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
great thank you
Do you have it somehow else? If so, could you attach your file (or sample where it does not match)?
sample.xlsx