Hi, this is my first post so I want to apologise in advance for my very basic knowledge of excel.
I have a spreadsheet that has been created by the company for overtime hours. On the main page there are two columns for the start time and end time of the overtime. They have a tab converting minutes into their decimal place value (I.e. 30 mins = 0.5). So if I have worked between 9.00 and 11.30 in the morning being 2 1/2hrs Currently I just need to use the table to work out the minutes value and type in the third column 2.5. But there must be a simple formula to work out the difference between column 1 and 2 and then lookup the minutes decimal value on the other tab. I would really appreciate any help without using macros as work will not accept those.
I have a spreadsheet that has been created by the company for overtime hours. On the main page there are two columns for the start time and end time of the overtime. They have a tab converting minutes into their decimal place value (I.e. 30 mins = 0.5). So if I have worked between 9.00 and 11.30 in the morning being 2 1/2hrs Currently I just need to use the table to work out the minutes value and type in the third column 2.5. But there must be a simple formula to work out the difference between column 1 and 2 and then lookup the minutes decimal value on the other tab. I would really appreciate any help without using macros as work will not accept those.