Subtract last column from first column

Forum Office software Excel
Report Subtract last column from first column
Ask a questionGaurav Kumar - Last answered on Sep 18, 2017 at 01:29 AM by Gauravkumar
Hello,



I am having a problem i have a excel sheet there are the data for various employees timing. first of all i want to search the last column and then i want to subtract that selected column from the column i have already mentioned. please help

Ex: employee name punchin punch punch punch punch
xyz 12.30 1.00 1.15 2.15
abc 1.30 4.15 5.17 8.20 9.00

first i want to search the last column in a row and then i want to subtract them from first punch this process will be in loop.

Thanks in advance

Your attachment link is not working

this is the attached file i need to subtract last column from first in a same row...and all rows have different last column...so i need to search the last column in each row and then subtract that last column from the column C in all rows by loop

I have a couple of questions, because your post is unclear.

Are these values actually times, or decimal values as displayed which have to be converted to times?
Will these times always be in a 24 hour day, and always sequenced from earliest punch in to latest punchin?
It could be as simple as =MAX(B1:F1)-B1

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

=MAX(E3:BB3)-E3 will work, provided all times are within one day.

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

yes it is working but i want it in macro code with loop

if i use this formula then i need to add this formula one by one on each row. but i need that i will execute a macro and it will calculate me whole the table on a single click

I want this to be done by macro only because it is a requirement of my project

Thanxx this code is working can you please explain this code

Hi Sir i need one more formula also which calculate punch in 3 subtract punch in 2 and punch in 5 subtract punch 4 punch 7 subtract punch 5 and add all this and subtract that number from the spent time and write it on effieient time like this example of row 4 =(C4-((G4-F4)+(I4-H4)+(K4-J4)+(M4-L4))) i want to calculate that time until the last number will come

i need that formula in excel not in macro

where can i see that post #9 please share me the link

Yes this is working can you please explain me this formula

Hi Kaper,

i am using this formula and it is working fine but when i insert a blank column the sum of product would not be calculated its showing me ########## only. can you please help me.

Thnxx kaper for your help