Forum Discussion
Excel Formula Assistance
Hi to All,
As you can see below I have an example on one of my data, and by looking at the downtime duration the answer of it is wrong, what I want to achieve is that I need to count the hours and minutes, including the days the downtime occurred while having considering the shift per each day has passed, can anyone help give some formulas for this conundrum.
| Shift Start | Shift End | Start Date | Start Time | End Date | End Time | Downtime Duration |
| 6:00:00 AM | 8:59:59 PM | 2/22/2020 | 2:40:00 PM | 2/24/2020 | 5:03:00 PM | 02:23:00 |
11 Replies
Not sure how you want to factor in the shift time, but you probably had the correct formula in G2. Try formatting it (custom format) [h]:mm. Then Excel will keep counting when you exceed 24 hours.
Hi thank you for your input, actually sorry for not mentioning it earlier, that data on G2 was given and not calculated using a formula, if you can give me an idea on how to calculate them properly, then I'll try to think on a way to factor in the daily shifts in between
Faust25 I had entered my formula is in G5. It's visible at the top in the first picture.
=E2+F2-C2-D2It takes End date plus End time minus Start date minus Start time. That gives you a total of 50 hours and 23 minutes. But, I didn't save the file I worked in so now I made a new one, with some formulae and formatting examples. Hope it helps you in fixing your own schedule.
