Input hours and minutes

[markmac234]

Hi
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.

Mac

 

[markmac234]

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,
Mac

 

[bullit_nl]

Thanks to Aladin my problem is solved. Why it won't work for you?

 

[IML]

How is this formula failing you?

With 1.15 in A1, you could use
=INT(A1)/24+MOD(A1,1)/14.4

with an approriate time format to reflect 1:15

 

[markmac234]

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.
Mac