Forum Discussion

Faust25's avatar
Faust25
Copper Contributor
Mar 19, 2020

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 an...
excel
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Mar 20, 2020

Faust25 My hospitality is almost endless! But my understanding for your business is limited. What I did, is incorporated my "all-in-one" formula in the data that you have in your sheet.

 

See attached. I hope you find it helpful. 

Faust25's avatar
Faust25
Copper Contributor
Mar 21, 2020

HiRiny_van_Eekelen,

 

I'm getting confused on the output of your formula, I tried tweaking it, but to no avail, I attached the file that shout be the output (the formula is not right, I just wrote the output).

 

Thank you

  • Faust25's avatar
    Faust25
    Copper Contributor
    Mar 21, 2020

    Hi,Riny_van_Eekelen

     

    Works fine bro, maybe just need to do some conditional IF statement on the formula and it will be all good, will try it if will work.

     

    Thank again. 

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Mar 21, 2020

    Faust25 Please see attached! Re-worked the formula completely.

     

    BUT!!!! I will only work in very similar cases. From another post you did here under a different name, I saw that your real data is much more complicated.

Resources