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