Subtract last column from first column [Solved/Closed]

Ask a question Gaurav Kumar - Last answered on Sep 18, 2017 at 03:26 AM by vcoolio

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
plus moins
OK, so lets say your sheet is formatted as so:

Do you wish to have cell F1 subtracted from C1?

Gauravkumar- Sep 18, 2017 at 01:29 AM
Yes i wanted to subtract F1 from C1 but the problem is in all rows the punch is in different place some have on F1 some on G2 some on H3 i want to subtract that last from the first column of that row
plus moins
Hello GauravKumar,

As you have mostly received a resolution to your query here:-

and in order that the Volunteers here no longer waste their time on this cross-posted thread, I will now close this thread and mark it as solved.

In future, before posting, kindly read the Policies Charter here and the rules of other forums in relation to cross-posting without notification.

Please remember that our Volunteers' time is just as valuable as yours.

I trust that you understand.


Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!