I've not really used the Excel time functionality before, and I admit I'm finding it a bit tricky!
I'm trying to create a simple spreadsheet to calculate number of hours to pay someone.
Information I have is start time, finish time and number of minutes for lunchbreak.
My simple formula subtracts start time and lunch minutes from end time, to give me total payable hours.
My problem is when summing these hours, I can't stop the formula expressing the answer in days (whereas I want it to always give me the total number of hours).
The attached spreadsheet shows the issue. I want the second batch total to read 25:15
(I predict this will probably be one of the simplest queries ever posted in the Lounge, but try as I might, I can't find the answer myself...!)