How to modify 60 Mins of Hours to 100 Minute a hour in Excel

**Saudamini** · 27-01-2012

I have this formula set up in excel. =FLOOR(F5,1/24)+VLOOKUP(MINUTE(F5),FORMULA!A1:B5,2). It returns 5:45, I would like it to return 5:75. What do I need to change in my formula to make it read in the 100 min. hour instead of 60 min. hour. I have a seperate column doing this, but would like to accomplish it within one column.

**Orion lella** · 27-01-2012

Do you really want 5:75. Do you want to be able to do calculations based on the result or just display it. I have a small formula which can help you to calculate the time. in this you can see =HOUR(B1-A1)*60+MINUTE(B1-A1) -- 60 as minute. Instead of that just put 100 and then try back. I think you might get the correct answer.

**Umberto-Micro** · 27-01-2012

It is possible to play with time in Microsoft Excel. All you need is to find a proper reference. Because the formula is only thing which can help you and that too manually. There is no actual reference directly provided in Excel that can show how to modify the hour minuts. Might be possible via visual basic.
Convert times
http://office.microsoft.com/en-us/ex...003056110.aspx