I am having difficulty inputting hours and minutes. I want to enter the time like 1.15 and not 75 mins. Any ideas? I have formatted the result column as h:mm but because of the decimal time problem, I can't find a way to enter the data.
Thanks for all of your replies. I have managed to get it to work, but as with bullit_nl's post, I would love to enter my hours as 1.15 and not 1:15. Until I get that to work I will continue entering time with the colon. Thanks again,
The formula works, I agree. But I am using the column that the formula refers to for a running total per row. So column A is the item, B the input hours (e.g 1.5) and C is the running total for that row. All the rows are not related and I have not found a way to keep a running total without using VB code. So what I'm after is a way of doing what your frmula says, but in code for my worksheet.