none
Userforum RRS feed

  • Question

  • Hi,

    I have a sheet that keeps record of all the breakdowns i have at work.

    I'm using a userforum to add the breakdowns to a sheet, on the user forum i have 6 textboxes where the users should enter data.

    The first 4 textboxes is basically 'start date, start time, end date and end time' in the last textbox i want the user to see the total downtime?

    Is there any ways i can add a formula to the textbox?

    Below is the formula I use on a normal spreadsheet.

    =IF(AND(E14>0,H14>0,F14>0,I14>0),IF(E14=H14,I14-F14,IF(E14<H14,(H14-E14)+(I14-F14),"")),0)

    Please help?


    Thanks you very much

    Tuesday, September 4, 2012 5:39 PM

All replies