Hello,
I would like to determine downtime in hours between two dates and times. In the attached excel sheet I have where you can enter the date and time down in B5 and date and time up in F5. On the shift hours tab it shows the hours for all three shifts. I would like for H5-J5 on the original tab to have formulas to display hours for each shift the machine has been down for. If anyone can help thanks alot.
Hi,
this is an interesting problem. Please see the attached sheet for a possible solution. I've used 3 rows to calculate the downtime for each breakdown.
Also, this assumes the breakdown gets rectified within the week. If there are longer breakdown periods, that can be accommodated by populating the columns further to the right.
Give it a whirl and let me know if you have any questions.
Cheers
Last edited by amit.wilson; 11-12-2013 at 12:16 AM. Reason: Multiple attachments
<-- If you're happy & you know it...click the star.:-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks