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.
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...
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
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.
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.
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.
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...
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...
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.
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...
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
Hi
I'm trying to put together a pivot table to show the values only but for some reason when I drag the range into the Value section and I click into the value field setting and choose show value as . It's gray out.
I don't want to show the sum of the values just the value as it is.
Please help...
Hi
I've combined a sumifand indirect formula but its only adding figures in one column instead of two
Can anyone correct my formula so that it adds two or more column .
Below is my formula...
Hi
I've made changes and it still doesn't work. When I change the status in cell B11 the rates is suppose to change but it's not picking up the correct rate.
Hi
I used a vlookup and match formula in my excel spreadsheet but for some reason it's not working properly.
Can someone please check my formula and advise what is wrong.
Please refer to my excel file. My formula is in the Rates column (AH4) It's not picking up the correct rate base on the...