• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by jrl1208

  1. J

    Assist with formula to convert min to percentage of an hour

    Sorry if i missed your question. The data from the Biotime is an export from the system which needs to be entered into HR3. However HR3 can't accept the existing time format. It has to be converted hence why i need the formula which you have provided. I hope this makes sense. Thank you.
  2. J

    Assist with formula to convert min to percentage of an hour

    Sorry i wasn't being clear. What i'm trying to do is convert the table with the heading Bio Time ( hours/ min) to percentage in hours in the other table with the heading HR3. The formula you provide is perfect. However, the daily total hours from the Bio Table ( M-T) should total 8hrs in total...
  3. J

    Assist with formula to convert min to percentage of an hour

    Thank you so much. I also want to modify the LWP cell. If there is a value in Cell G6 then carried out the calculation plus on top of that do a IF(SUM(J6:M6)<=8,8-SUM(J6:M6)). How can I modify it. Thank you
  4. J

    Assist with formula to convert min to percentage of an hour

    Hi I'm trying to write up a formula to convert the minute into percentage of an hour (Eg 2.25 = (25/60)+2) I'm struggling to get the correct formula to work. Any kind of help would be appreciated. File is attached with the formula which requires modification. Thank you.
  5. J

    Formula assistance

    Thank you bosco_yip and Srindhi
  6. J

    Formula assistance

    Hi Ali Thank you so much for the formula. However, when I applied the formula, it didn't work on all the cells. Please refer to the attached excel spreadsheet Cell E17 Thank you.
  7. J

    Formula assistance

    Hi I’m currently using a vlookup formula in my summary tab for each of my heading in Cell E1 to H1. For the vlookup to work I need to sort the data by type first. Is there a better formula to use without the need to sort the data by type. Any assistance will be greatly appreciated. Thank you.
  8. J

    how to show percentage as value in pivot table

    Hi I'm wanting to know how show percentage as a value in a pivot table. I want to know how to remove calculation. I tried using the value field setting and choose no calculation but it's still showing the percentage as a calculation not value. Also in the subtotal column, i don't want to show...
  9. J

    Formula Help

    Thank you Bosco
  10. J

    Formula Help

    Hi Pavan Thank you for the reply. Can I ask how did you display the destination and equip group chart? It's good but not exactly what I wanted. I still prefer a formula that picks up multiply free time for different shipping co as there are more than 50 Destination state. The chart will be...
  11. J

    Formula Help

    Yes i would need all the possible time frame base on shipping Co. I want to be able to select the destination state , equipment group and the result will show me all the possible time frame available from all shipping co.
  12. J

    Formula Help

    Hi I would like to know if there is a formula i can use to give me a certain result Example : I want to select a destination state ( Column D) and then it will automatically give me the free time(colomn G) from the different shipping co (Database worksheet) At the moment I can only get the...
  13. J

    Help with Pivot Table - show value as

    Please ignore my previous request. I found out the reason why it didn't work. I had cell had the currency in it instead of a whole number. that was the cause. thanks Narayan for your help
  14. J

    Help with Pivot Table - show value as

    Sorry but I tried to follow the link you provided but it doesn't seem to be working.
Back
Top